This section describes how to migrate to the ASE ODBC Driver by Sybase and ASE OLE DB Provider by Sybase.
To migrate your applications from the ODBC Driver Kit to the ASE ODBC Driver by Sybase, be sure to complete the following steps:
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.
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 “ODBC DSN Migration tool available”.
Known differences in behavior between the ODBC Driver Kit and the ASE ODBC Driver by Sybase are documented in the SDK Version 15.0 Release Bulletin for your platform.
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.
To migrate OLE DB applications to use the ASE OLE DB Provider by Sybase, you must edit the connection string used by OLE DB client applications. The provider short name for the ASE OLE DB Provider by Sybase is “ASEOLEDB.”
Known differences in behavior between the OLE DB Driver Kit and ASE OLE DB Provider by Sybase are documented in the SDK 15.0 Release Bulletin for your platform.
The connection string syntax for ASE OLE DB Provider
by Sybase is documented in the Adaptive Server Enterprise OLE DB Provider by Sybase User’s
Guide for Microsoft Windows.
The connection string syntax differs from the syntax for the OLE DB Driver Kit. The OLE DB Provider by Sybase honors the OLE DB Driver Kit syntax, but Sybase recommends that you migrate your connection string syntax to the new syntax when possible.
