Retorna um array com os dados dos drivers ODBC instalados na máquina em que está o DBAccess.
Sintaxe
TCDrivers()
Retorno
Nome | Tipo | Descrição |
|---|---|---|
aRet | vetor | Retorna um array com os dados dos drivers ODBC instalados na máquina em que está o DBAccess. |
Atenção
Esta função não está disponível para uso com RPODB=SQLITE.
Observações
- É necessário conexão prévia com o DBAccess usando um Driver ODBC para executar essa função.
- Cada item do array de retorno corresponde a um driver cadstrado e contém 2 informações: o índice 1 contém o nome do driver e o índice 2 contém um array com todos os atributos desse driver.
Exemplos
user function teste() TCLink() varinfo( "driver", TCDrivers() ) TCUnlink() return 0
// Exemplo de retorno da função
driver -> ARRAY ( 27) [...]
driver[1] -> ARRAY ( 2) [...]
driver[1][1] -> C ( 54) [Driver da Microsoft para arquivos texto (*.txt; *.csv)]
driver[1][2] -> ARRAY ( 7) [...]
driver[1][2][1] -> C ( 10) [APILevel=1]
driver[1][2][2] -> C ( 20) [ConnectFunctions=YYN]
driver[1][2][3] -> C ( 19) [DriverODBCVer=02.50]
driver[1][2][4] -> C ( 42) [FileExtns=*.,*.asc,*.csv,*.tab,*.txt,*.csv]
driver[1][2][5] -> C ( 11) [FileUsage=1]
driver[1][2][6] -> C ( 10) [SQLLevel=0]
driver[1][2][7] -> C ( 12) [UsageCount=1]
driver[2] -> ARRAY ( 2) [...]
driver[2][1] -> C ( 34) [Driver do Microsoft Access (*.mdb)]
driver[2][2] -> ARRAY ( 7) [...]
driver[2][2][1] -> C ( 10) [APILevel=1]
driver[2][2][2] -> C ( 20) [ConnectFunctions=YYN]
driver[2][2][3] -> C ( 19) [DriverODBCVer=02.50]
driver[2][2][4] -> C ( 15) [FileExtns=*.mdb]
driver[2][2][5] -> C ( 11) [FileUsage=2]
driver[2][2][6] -> C ( 10) [SQLLevel=0]
driver[2][2][7] -> C ( 12) [UsageCount=1]
driver[3] -> ARRAY ( 2) [...]
driver[3][1] -> C ( 33) [Driver do Microsoft dBase (*.dbf)]
driver[3][2] -> ARRAY ( 7) [...]
driver[3][2][1] -> C ( 10) [APILevel=1]
driver[3][2][2] -> C ( 20) [ConnectFunctions=YYN]
driver[3][2][3] -> C ( 19) [DriverODBCVer=02.50]
driver[3][2][4] -> C ( 27) [FileExtns=*.dbf,*.ndx,*.mdx]
driver[3][2][5] -> C ( 11) [FileUsage=1]
driver[3][2][6] -> C ( 10) [SQLLevel=0]
driver[3][2][7] -> C ( 12) [UsageCount=1]
driver[4] -> ARRAY ( 2) [...]
driver[4][1] -> C ( 32) [Driver do Microsoft Excel(*.xls)]
driver[4][2] -> ARRAY ( 7) [...]
driver[4][2][1] -> C ( 10) [APILevel=1]
driver[4][2][2] -> C ( 20) [ConnectFunctions=YYN]
driver[4][2][3] -> C ( 19) [DriverODBCVer=02.50]
driver[4][2][4] -> C ( 15) [FileExtns=*.xls]
driver[4][2][5] -> C ( 11) [FileUsage=1]
driver[4][2][6] -> C ( 10) [SQLLevel=0]
driver[4][2][7] -> C ( 12) [UsageCount=1]
driver[5] -> ARRAY ( 2) [...]
driver[5][1] -> C ( 35) [Driver do Microsoft Paradox (*.db )]
driver[5][2] -> ARRAY ( 7) [...]
driver[5][2][1] -> C ( 10) [APILevel=1]
driver[5][2][2] -> C ( 20) [ConnectFunctions=YYN]
driver[5][2][3] -> C ( 19) [DriverODBCVer=02.50]
driver[5][2][4] -> C ( 14) [FileExtns=*.db]
driver[5][2][5] -> C ( 11) [FileUsage=1]
driver[5][2][6] -> C ( 10) [SQLLevel=0]
driver[5][2][7] -> C ( 12) [UsageCount=1]
driver[6] -> ARRAY ( 2) [...]
driver[6][1] -> C ( 31) [Microsoft Access Driver (*.mdb)]
driver[6][2] -> ARRAY ( 7) [...]
driver[6][2][1] -> C ( 10) [APILevel=1]
driver[6][2][2] -> C ( 20) [ConnectFunctions=YYN]
driver[6][2][3] -> C ( 19) [DriverODBCVer=02.50]
driver[6][2][4] -> C ( 15) [FileExtns=*.mdb]
driver[6][2][5] -> C ( 11) [FileUsage=2]
driver[6][2][6] -> C ( 10) [SQLLevel=0]
driver[6][2][7] -> C ( 12) [UsageCount=1]
driver[7] -> ARRAY ( 2) [...]
driver[7][1] -> C ( 32) [Microsoft Access-Treiber (*.mdb)]
driver[7][2] -> ARRAY ( 7) [...]
driver[7][2][1] -> C ( 10) [APILevel=1]
driver[7][2][2] -> C ( 20) [ConnectFunctions=YYN]
driver[7][2][3] -> C ( 19) [DriverODBCVer=02.50]
driver[7][2][4] -> C ( 15) [FileExtns=*.mdb]
driver[7][2][5] -> C ( 11) [FileUsage=2]
driver[7][2][6] -> C ( 10) [SQLLevel=0]
driver[7][2][7] -> C ( 12) [UsageCount=1]
driver[8] -> ARRAY ( 2) [...]
driver[8][1] -> C ( 30) [Microsoft dBase Driver (*.dbf)]
driver[8][2] -> ARRAY ( 7) [...]
driver[8][2][1] -> C ( 10) [APILevel=1]
driver[8][2][2] -> C ( 20) [ConnectFunctions=YYN]
driver[8][2][3] -> C ( 19) [DriverODBCVer=02.50]
driver[8][2][4] -> C ( 27) [FileExtns=*.dbf,*.ndx,*.mdx]
driver[8][2][5] -> C ( 11) [FileUsage=1]
driver[8][2][6] -> C ( 10) [SQLLevel=0]
driver[8][2][7] -> C ( 12) [UsageCount=1]
driver[9] -> ARRAY ( 2) [...]
driver[9][1] -> C ( 31) [Microsoft dBase-Treiber (*.dbf)]
driver[9][2] -> ARRAY ( 7) [...]
driver[9][2][1] -> C ( 10) [APILevel=1]
driver[9][2][2] -> C ( 20) [ConnectFunctions=YYN]
driver[9][2][3] -> C ( 19) [DriverODBCVer=02.50]
driver[9][2][4] -> C ( 27) [FileExtns=*.dbf,*.ndx,*.mdx]
driver[9][2][5] -> C ( 11) [FileUsage=1]
driver[9][2][6] -> C ( 10) [SQLLevel=0]
driver[9][2][7] -> C ( 12) [UsageCount=1]
driver[10] -> ARRAY ( 2) [...]
driver[10][1] -> C ( 30) [Microsoft Excel Driver (*.xls)]
driver[10][2] -> ARRAY ( 7) [...]
driver[10][2][1] -> C ( 10) [APILevel=1]
driver[10][2][2] -> C ( 20) [ConnectFunctions=YYN]
driver[10][2][3] -> C ( 19) [DriverODBCVer=02.50]
driver[10][2][4] -> C ( 15) [FileExtns=*.xls]
driver[10][2][5] -> C ( 11) [FileUsage=1]
driver[10][2][6] -> C ( 10) [SQLLevel=0]
driver[10][2][7] -> C ( 12) [UsageCount=1]
driver[11] -> ARRAY ( 2) [...]
driver[11][1] -> C ( 31) [Microsoft Excel-Treiber (*.xls)]
driver[11][2] -> ARRAY ( 7) [...]
driver[11][2][1] -> C ( 10) [APILevel=1]
driver[11][2][2] -> C ( 20) [ConnectFunctions=YYN]
driver[11][2][3] -> C ( 19) [DriverODBCVer=02.50]
driver[11][2][4] -> C ( 15) [FileExtns=*.xls]
driver[11][2][5] -> C ( 11) [FileUsage=1]
driver[11][2][6] -> C ( 10) [SQLLevel=0]
driver[11][2][7] -> C ( 12) [UsageCount=1]
driver[12] -> ARRAY ( 2) [...]
driver[12][1] -> C ( 25) [Microsoft ODBC for Oracle]
driver[12][2] -> ARRAY ( 7) [...]
driver[12][2][1] -> C ( 10) [APILevel=1]
driver[12][2][2] -> C ( 20) [ConnectFunctions=YYY]
driver[12][2][3] -> C ( 13) [CPTimeout=120]
driver[12][2][4] -> C ( 19) [DriverODBCVer=02.50]
driver[12][2][5] -> C ( 11) [FileUsage=0]
driver[12][2][6] -> C ( 10) [SQLLevel=1]
driver[12][2][7] -> C ( 12) [UsageCount=1]
driver[13] -> ARRAY ( 2) [...]
driver[13][1] -> C ( 32) [Microsoft Paradox Driver (*.db )]
driver[13][2] -> ARRAY ( 7) [...]
driver[13][2][1] -> C ( 10) [APILevel=1]
driver[13][2][2] -> C ( 20) [ConnectFunctions=YYN]
driver[13][2][3] -> C ( 19) [DriverODBCVer=02.50]
driver[13][2][4] -> C ( 14) [FileExtns=*.db]
driver[13][2][5] -> C ( 11) [FileUsage=1]
driver[13][2][6] -> C ( 10) [SQLLevel=0]
driver[13][2][7] -> C ( 12) [UsageCount=1]
driver[14] -> ARRAY ( 2) [...]
driver[14][1] -> C ( 33) [Microsoft Paradox-Treiber (*.db )]
driver[14][2] -> ARRAY ( 7) [...]
driver[14][2][1] -> C ( 10) [APILevel=1]
driver[14][2][2] -> C ( 20) [ConnectFunctions=YYN]
driver[14][2][3] -> C ( 19) [DriverODBCVer=02.50]
driver[14][2][4] -> C ( 14) [FileExtns=*.db]
driver[14][2][5] -> C ( 11) [FileUsage=1]
driver[14][2][6] -> C ( 10) [SQLLevel=0]
driver[14][2][7] -> C ( 12) [UsageCount=1]
driver[15] -> ARRAY ( 2) [...]
driver[15][1] -> C ( 36) [Microsoft Text Driver (*.txt; *.csv)]
driver[15][2] -> ARRAY ( 7) [...]
driver[15][2][1] -> C ( 10) [APILevel=1]
driver[15][2][2] -> C ( 20) [ConnectFunctions=YYN]
driver[15][2][3] -> C ( 19) [DriverODBCVer=02.50]
driver[15][2][4] -> C ( 42) [FileExtns=*.,*.asc,*.csv,*.tab,*.txt,*.csv]
driver[15][2][5] -> C ( 11) [FileUsage=1]
driver[15][2][6] -> C ( 10) [SQLLevel=0]
driver[15][2][7] -> C ( 12) [UsageCount=1]
driver[16] -> ARRAY ( 2) [...]
driver[16][1] -> C ( 37) [Microsoft Text-Treiber (*.txt; *.csv)]
driver[16][2] -> ARRAY ( 7) [...]
driver[16][2][1] -> C ( 10) [APILevel=1]
driver[16][2][2] -> C ( 20) [ConnectFunctions=YYN]
driver[16][2][3] -> C ( 19) [DriverODBCVer=02.50]
driver[16][2][4] -> C ( 42) [FileExtns=*.,*.asc,*.csv,*.tab,*.txt,*.csv]
driver[16][2][5] -> C ( 11) [FileUsage=1]
driver[16][2][6] -> C ( 10) [SQLLevel=0]
driver[16][2][7] -> C ( 12) [UsageCount=1]
driver[17] -> ARRAY ( 2) [...]
driver[17][1] -> C ( 10) [SQL Server]
driver[17][2] -> ARRAY ( 7) [...]
driver[17][2][1] -> C ( 10) [APILevel=2]
driver[17][2][2] -> C ( 20) [ConnectFunctions=YYY]
driver[17][2][3] -> C ( 12) [CPTimeout=60]
driver[17][2][4] -> C ( 19) [DriverODBCVer=03.50]
driver[17][2][5] -> C ( 11) [FileUsage=0]
driver[17][2][6] -> C ( 10) [SQLLevel=1]
driver[17][2][7] -> C ( 12) [UsageCount=1]
driver[18] -> ARRAY ( 2) [...]
driver[18][1] -> C ( 26) [MySQL ODBC 5.3 ANSI Driver]
driver[18][2] -> ARRAY ( 1) [...]
driver[18][2][1] -> C ( 12) [UsageCount=1]
driver[19] -> ARRAY ( 2) [...]
driver[19][1] -> C ( 29) [MySQL ODBC 5.3 Unicode Driver]
driver[19][2] -> ARRAY ( 1) [...]
driver[19][2][1] -> C ( 12) [UsageCount=1]
driver[20] -> ARRAY ( 2) [...]
driver[20][1] -> C ( 15) [PostgreSQL ANSI]
driver[20][2] -> ARRAY ( 6) [...]
driver[20][2][1] -> C ( 10) [APILevel=1]
driver[20][2][2] -> C ( 20) [ConnectFunctions=YYN]
driver[20][2][3] -> C ( 19) [DriverODBCVer=03.50]
driver[20][2][4] -> C ( 11) [FileUsage=0]
driver[20][2][5] -> C ( 10) [SQLLevel=1]
driver[20][2][6] -> C ( 12) [UsageCount=1]
driver[21] -> ARRAY ( 2) [...]
driver[21][1] -> C ( 18) [PostgreSQL Unicode]
driver[21][2] -> ARRAY ( 6) [...]
driver[21][2][1] -> C ( 10) [APILevel=1]
driver[21][2][2] -> C ( 20) [ConnectFunctions=YYN]
driver[21][2][3] -> C ( 19) [DriverODBCVer=03.51]
driver[21][2][4] -> C ( 11) [FileUsage=0]
driver[21][2][5] -> C ( 10) [SQLLevel=1]
driver[21][2][6] -> C ( 12) [UsageCount=1]
driver[22] -> ARRAY ( 2) [...]
driver[22][1] -> C ( 29) [ODBC Driver 13 for SQL Server]
driver[22][2] -> ARRAY ( 7) [...]
driver[22][2][1] -> C ( 12) [UsageCount=1]
driver[22][2][2] -> C ( 10) [APILevel=2]
driver[22][2][3] -> C ( 20) [ConnectFunctions=YYY]
driver[22][2][4] -> C ( 12) [CPTimeout=60]
driver[22][2][5] -> C ( 19) [DriverODBCVer=03.80]
driver[22][2][6] -> C ( 11) [FileUsage=0]
driver[22][2][7] -> C ( 10) [SQLLevel=1]
driver[23] -> ARRAY ( 2) [...]
driver[23][1] -> C ( 29) [SQL Server Native Client 11.0]
driver[23][2] -> ARRAY ( 7) [...]
driver[23][2][1] -> C ( 12) [UsageCount=1]
driver[23][2][2] -> C ( 10) [APILevel=2]
driver[23][2][3] -> C ( 20) [ConnectFunctions=YYY]
driver[23][2][4] -> C ( 12) [CPTimeout=60]
driver[23][2][5] -> C ( 19) [DriverODBCVer=03.80]
driver[23][2][6] -> C ( 11) [FileUsage=0]
driver[23][2][7] -> C ( 10) [SQLLevel=1]
driver[24] -> ARRAY ( 2) [...]
driver[24][1] -> C ( 28) [Oracle in instantclient_11_2]
driver[24][2] -> ARRAY ( 6) [...]
driver[24][2][1] -> C ( 10) [APILevel=1]
driver[24][2][2] -> C ( 23) [ConnectionFunctions=YYY]
driver[24][2][3] -> C ( 12) [CPTimeout=60]
driver[24][2][4] -> C ( 19) [DriverODBCVer=03.51]
driver[24][2][5] -> C ( 11) [FileUsage=0]
driver[24][2][6] -> C ( 10) [SQLLevel=1]
driver[25] -> ARRAY ( 2) [...]
driver[25][1] -> C ( 28) [Oracle in instantclient_12_2]
driver[25][2] -> ARRAY ( 6) [...]
driver[25][2][1] -> C ( 10) [APILevel=1]
driver[25][2][2] -> C ( 23) [ConnectionFunctions=YYY]
driver[25][2][3] -> C ( 12) [CPTimeout=60]
driver[25][2][4] -> C ( 19) [DriverODBCVer=03.51]
driver[25][2][5] -> C ( 11) [FileUsage=0]
driver[25][2][6] -> C ( 10) [SQLLevel=1]
driver[26] -> ARRAY ( 2) [...]
driver[26][1] -> C ( 24) [IBM INFORMIX ODBC DRIVER]
driver[26][2] -> ARRAY ( 5) [...]
driver[26][2][1] -> C ( 10) [APILevel=1]
driver[26][2][2] -> C ( 20) [ConnectFunctions=YYY]
driver[26][2][3] -> C ( 19) [DriverODBCVer=03.51]
driver[26][2][4] -> C ( 11) [FileUsage=0]
driver[26][2][5] -> C ( 10) [SQLLEVEL=1]
driver[27] -> ARRAY ( 2) [...]
driver[27][1] -> C ( 41) [IBM DB2 ODBC DRIVER - d_db2_x86_clidriver]
driver[27][2] -> ARRAY ( 2) [...]
driver[27][2][1] -> C ( 12) [UsageCount=1]
driver[27][2][2] -> C ( 12) [CPTimeout=60]
Abrangência
A função TCDrivers está disponível a partir da build 7.00.170117A do TOTVS | Application Server com data de geração superior a 04/05/2018, bem como build do TOTVS | DBAccess superior a 20171117, juntamente com a DBApi da mesma versão atualizada no TOTVS | Application Server.
Veja também
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas