I am attempting to migrate one of our CT-Lib based programs to use
Microsoft's Native ODBC. The server version is Adaptive Server
Enterprise 15.5. Everything appears to work fine (connections,
executing and fetching data, etc.) with the exception of creating a
connection descriptor handle using SQL_HANDLE_DESC. It gives me a
return code -2 (invalid handle?), but no diagnostic messages. I'm
doing this after opening the connection, because when I tried it prior
to opening the connection, it issued an error that the connection was
not yet open.
The driver is Adapter Server Enterprise SYBDRVODB.DLL, version
15.05.00.1022, dated 9/8/2010.
I want to set the precision and scale limits for amounts. That is the
reason for the descriptor handle. We also have a version of this
program for MS SQL, using Native ODBC, and it works without error.
Does anyone have any suggestions? I'd appreciate your input.
If you know of a location for Sybase ODBC function documentation, I'd
also appreciate that.
Thanks,
Greg