7.3.4. ODBC Compliance
The Virtuoso Driver for ODBC conforms to both the ODBC 1.x,2.x and 3.x versions of the ODBC specification. It implements Core, Level 1, Level 2 and Extensions functionality. It also has a native support for the wide versions of the ODBC API (e.g. SQLColumnsW) in Windows. This driver enables you to communicate with local or remote Virtuoso servers across any combination of platforms supported by Virtuoso.
ODBC API implementation details
SQLAllocHandle
Virtuoso ODBC driver does not allow allocation and usage of explicitly allocated descriptor handles. That is why the SQLAllocHandle (SQL_HANDLE_DESC) will return an error.
SQLBulkOperations
Only the SQL_ADD operation is supported.
SQLColAttributes
The virtuoso ODBC driver does not return information for the following attributes:
- SQL_COLUMN_TABLE_NAME
-
Returns an empty string instead
- SQL_COLUMN_OWNER_NAME
-
Returns an empty string instead
- SQL_COLUMN_QUALIFIER_NAME
-
Returns an empty string instead
- SQL_COLUMN_CASE_SENSITIVE
-
Returns 1 instead
- SQL_COLUMN_AUTO_INCREMENT
-
Returns 0 instead
- SQL_COLUMN_MONEY
-
Returns 0 instead
- SQL_COLUMN_UNSIGNED
-
Returns 0 instead
SQLDriverConnect
The Virtuoso ODBC driver recognizes the following SQLDriverConnect connection string keywords:
- DSN
-
The data source name.
- HOST
-
The virtuoso server host specification (in the form : [<hostname>[:]][<portnumber>]
- UID
-
The virtuoso user ID used to connect
- PWD
-
The login password used to connect
- DATABASE
-
The qualifier to use when connected (overrides the user's default qualifier)
- CHARSET
-
The name of the character set to use for wide/narrow conversions
- DAYLIGHT
-
Boolean parameter (1/0). When ON (1) it takes into account the client OS daylight savings settings.
- ENCRYPT
-
String parameter (file name or "1"). Specifies how the ODBC connection will be encrypted. see the Using SSL For Secure ODBC connections for details.
- PWDCLEAR
-
Integer parameter (default to 0). Specifies how the password will be sent over the wire. 0 - send digest of the password, 1 - send password in cleartext, 2 - send password garbaled.
- SERVERCERT
-
String parameter (file name). Specifies the path for the CA list used to verify the server's certificate (in PEM format). see the Using SSL For Secure ODBC connections for details.
- FORCE_DBMS_NAME
-
String parameter (default "OpenLink Virtuoso"). When set it alters the result of SQLGetInfo (SQL_DBMS_NAME).
- NoSystemTables
-
Boolean parameter (1/0) (default 0). When set it alters the result of SQLTables () so that it won't find or return tables of type SYSTEM TABLE.
- IsolationLevel
-
String parameter ("Read Uncommitted"/"Read Committed"/"Repeatable Read"/"Serializable"). When set it specifies the initial transaction isolation mode for that connection.
SQLGetEnvAttr
The SQL_ATTR_OUTPUT_NTS does not have any effect on the Virtuoso driver. It allows the value to be set and retrieved but with no further effect.
SQLNativeSql
All ODBC syntax is parsed server side. The native SQL syntax for Virtuoso is the ODBC syntax.
Not Supported ODBC API functions
Virtuoso ODBC driver does not support the following ODBC API functions:
-
SQLCopyDesc