CSPColumnODBCVersion

Specifies the ODBC version that catalog stored procedures results conform to.

Syntax

CSPColumnODBC Version = [ 2 | 3 ]

Default

3

Values

  • 2 specifies Adaptive Server® Enterprise/Component Integration Services (CIS) version 12.0.

  • 3 specifies Adaptive Server/CIS version 12.5 and later.

Comment

This property affects interoperability with Adaptive Server/CIS. Change the value to 2 if you see:
Error 11209 - ‘column type mismatch in remote object’ when executing create existing table command to MSSQL server 2000SP 2.