ODBC Information

The ODBC definition of a CSP is the model, when the access service cannot support a particular procedure, it returns the expected column form descriptors, with no data rows.

See the Microsoft ODBC 3.5 Programmer’s Reference and SDK Guide for the format and content of results returned by most CSPs.

Compatibility

To maintain compatibility with Adaptive Server and previous versions of the MDI Database Gateway, all CSPs accomplish the same tasks as their counterparts in the other systems. However, in ECDA Option for ODBC:

  • The result sets returned conform to ODBC requirements.

  • The result sets returned conform to Adaptive Server/CIS requirements.

When a CSP requirements conflict arises, these rules are used, in this order:

  1. Make the results conform to ODBC specifications.

  2. Make the results conform to Adaptive Server/CIS specifications.

  3. Make the behavior of the procedure conform to its counterpart in Adaptive Server.

Parent topic: Catalog Stored Procedures