SQLGetInfo Values

The IDS_INFO_OFFSET values form a one-to-one mapping with the fInfoType values defined for SQLGetInfo in the Microsoft ODBC 2.0 Programmer's Reference and SDK Guide. Some of the values for IDS_INFO_OFFSET are actually SELECT statements that are executed when SQLGetInfo is called. This allows flexibility for data sources where the values might be dependent on the installation or on the individual user.

The IDS_SPROC_VERSION string is used to validate that the gateway's catalog stored procedures are the proper version. The Open Data Services ODBC driver gets the gateway's version by using sp_server_info 500. If the version in the resource is greater than the gateway's version, a warning message is returned when the connection is complete.