odbcGetInfo

0th

Percentile

Request Information on an ODBC Connection

Request information on an ODBC connection.

Keywords
IO, database
Usage
odbcGetInfo(channel)
Arguments
channel

connection handle as returned by odbcConnect of class "RODBC".

Value

A named character string giving information on the database and ODBC driver in use on the connection channel.

Aliases
  • odbcGetInfo
Examples
# NOT RUN {
odbcGetInfo(channel) # under Windows XP
## MySQL returned
             DBMS_Name               DBMS_Ver        Driver_ODBC_Ver
               "MySQL"     "5.1.35-community"                "03.51"
      Data_Source_Name            Driver_Name             Driver_Ver
             "testdb5"          "myodbc5.dll"           "05.01.0005"
              ODBC_Ver            Server_Name
          "03.52.0000" "localhost via TCP/IP"
## MS Access returned
       DBMS_Name         DBMS_Ver  Driver_ODBC_Ver Data_Source_Name
        "ACCESS"     "04.00.0000"          "03.51"        "testacc"
     Driver_Name       Driver_Ver         ODBC_Ver      Server_Name
  "odbcjt32.dll"     "04.00.6305"     "03.52.0000"         "ACCESS"
## SQL Server 2008 Express returned
             DBMS_Name               DBMS_Ver        Driver_ODBC_Ver
"Microsoft SQL Server"           "10.00.1600"                "03.52"
      Data_Source_Name            Driver_Name             Driver_Ver
           "SQLServer"          "SQLNCLI.DLL"           "09.00.4035"
              ODBC_Ver            Server_Name
          "03.52.0000"      "AUK\\SQLEXPRESS"
# }
Documentation reproduced from package RODBC, version 1.3-15, License: GPL-2 | GPL-3

Community examples

Looks like there are no examples yet.