Page tree
Skip to end of metadata
Go to start of metadata

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.

Observações

  • É necessário conexão prévia com o DBAccess 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

  • No labels