Open System Services ODBC/MX Client Driver Manual for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

3 ODBC/MX Conformance
This chapter contains tables that describe the ODBC/MX conformance to standard ODBC API
functions and SQL conformance levels.
ODBC API Functions
ODBC/MX conforms with the ODBC interface core level. The following tables show the ODBC/MX
support for each ODBC API function.
The column headed ODBC Version lists the version of the Microsoft ODBC standard in which a
function was first introduced. For example, if ODBC Version 1.0 is listed as supported, then the
feature was first defined in version 1.0 of the Microsoft ODBC standard and ODBC/MX currently
supports the functions.
For more information about each function, refer to the Microsoft documentation.
Table 3 Connecting to a Data Source
Description
Supported by
ODBC/MXODBC VersionFunction
Obtains an environment, connection,
statement, or descriptor handle.
Yes3.xSQLAllocHandle
Connects to a specific driver by data source
name, user ID, and password.
Yes1.0SQLConnect
Connects to a specific driver by connection
string.
Yes1.0SQLDriverConnect
Returns successive levels of connection
attributes and valid attribute values. When a
Yes1.0SQLBrowseConnect
value has been specified for each connection
attribute, connects to the data source.
Table 4 Obtaining Information About a Driver and Data Source
Description
Supported by
ODBC/MXODBC VersionFunction
Returns the list of available data sources. Implemented by
the Driver Manager.
Yes1.0SQLDataSources
Returns the list of installed drivers and their attributes.
Implemented by the Driver Manager.
Yes2.0SQLDrivers
Returns information about a specific driver and data source.
When used with the option SQL_USER_NAME, returns the
Schema name.
Yes1.0SQLGetInfo
Returns supported driver functions.Yes1.0SQLGetFunctions
Returns information about supported data types.Yes1.0SQLGetTypeInfo
Table 5 Setting and Retrieving Driver Attributes
Description
Supported by
ODBC/MXODBC VersionFunction
Sets a connection attribute.Yes3.xSQLSetConnectAttr
Returns the value of a connection attribute.Yes3.xSQLGetConnectAttr
Sets an environment attribute.Yes3.xSQLSetEnvAttr
Returns the value of an environment attribute.Yes3.xSQLGetEnvAttr
32 ODBC/MX Conformance