Changes to ODBC and OLE DB Driver support

Adaptive Server version 15.0 and later contains new ODBC and OLE DB drivers developed by Sybase. The third-party rebranded ODBC and OLE DB Driver Kits included with previous versions are no longer shipped.

The retired ODBC Driver Kit was installed in %SYBASE%\ODBC, and registered with the ODBC Driver Manager as “Sybase ODBC Driver.” The new Adaptive Server ODBC Driver by Sybase is installed in %SYBASE%\DataAccess\ODBC, and registered as “Adaptive Server Enterprise.” The version shipping with Adaptive Server and SDK 15.0 is version 15.0.2.

The retired OLE DB Driver Kit was installed in %SYBASE%\OLEDB, and used the provider short name of “SYBASE.OLEDBProvider” and the long name of “Sybase OLE DB Provider.” The new OLE DB Provider by Sybase is installed in %SYBASE%\DataAccess\OLEDB, and uses provider short name “OLEDB.” The version shipping with SDK 15.0 is version 15.0.2.

Sybase recommends that you update your ODBC Driver and OLE DB Provider to the new Sybase ODBC Driver and OLE DB Provider as soon as possible. Specifically, you should migrate:

For your convenience during the migration process, the third-party drivers and providers support connectivity to the 15.x version of Adaptive Server until November 29, 2007. They will not support new features added after Adaptive Server 12.5.3. Patches released after that date will perform a version check, and will not allow connection to Adaptive Server 15.x. This version-check behavior will only be incorporated in patches released after November 30, 2007. If patches released after November 30, 2007 are not applied, the third-party driver and provider can continue to connect to any versions of Adaptive Server available in the market.

See New Features for Open Server 15.0 and SDK 15.0 for Windows, Linux and UNIX, for instructions on migrating to the new drivers.

For more information on migrating to the new OLE DB Provider, see Open Server 15.0, Open Client 15.0 and SDK 15.0 and New Features Open Server 15.0 and SDK 15.0 for Microsoft Windows, Linux, and UNIX.