To migrate your applications from the ODBC Driver Kit to the ASE ODBC Driver by Sybase, be sure to complete the following procedure:
To migrate applications from ODBC Driver Kit to
ASE ODBC Driver by Sybase
Migrate DSNs.
You must recreate the DSNs you are using to utilize the ASE ODBC Driver by Sybase. Alternatively, you can create new DSNs with different names and change the DSN names in the application code. A DSN Migration tool is provided for this task.
Migrate ODBC application code.
If you created new DSNs with different names, you must change
the DSN names in the SQLConnect calls. You must
also change the SQLDriverConnect connection string
if you use Driver=Driver Name as the
driver name. The name of the ASE ODBC Driver by Sybase is “Adaptive
Server Enterprise”.
The ODBC DSN Migration tool helps you to migrate from the ODBC Driver Kit to the ODBC Driver by Sybase. More information on the tool is available in the “ODBC DSN Migration tool” section in the Open Server 12.5.1 and SDK 12.5.1 New Features for Microsoft Windows, Linux, and UNIX.
Known differences in behavior between the ODBC Driver Kit and the ASE ODBC Driver by Sybase are documented in “Unsupported ODBC features”.
The connection string syntax for ASE ODBC Driver by
Sybase is documented in the Adaptive Server Enterprise ODBC Driver
by Sybase User’s Guide for your platform.
The connection string syntax differs from the syntax for the ODBC Driver Kit. The ODBC Driver by Sybase honors the ODBC Driver Kit syntax, but Sybase recommends that you migrate your connection string syntax to the new syntax when possible.
