The following documentation provides workstation level instructions for the implementation of the Sybase ASE ODBC driver.

Sybase ASE drivers should now be used on all Sybase servers. The ODBC drivers from Openlink Software are no longer available.

ODBC is a supported database communications vehicle for query-based applications. No support for database updates (via ODBC) is available.

Windows 9X Implementation

Double click on the odbcsyb12.reg file in the t:\windows.95\ directory.

Windows NT/2000/XP Implementation

Double click on the odbcsyb12.reg file in the t:\windows.XX\ directory (where XX is one of NT,2K,XP).

Users of Windows NT/2000/XP and Office may be required to add a registry entry to fix a problem with the Sybase ASE driver specifically related to Microsoft Access. The entry should be placed in

HKEY_LOCAL_MACHINE/Software/ODBC/ODBC.INI
for User DSNs, and

HKEY_CURRENT_USER/Software/ODBC/ODBC.INI
for System DSNs

for each Data Source. It should be named WorkArounds2 and have a string value of 40960.

This fix will need to be applied if you are receiving a "reserved error" of -7748.

Macintosh Implementation

There are no supported drivers for the Macintosh.

Other Notes

The Sybase ASE ODBC drivers require the specification of a Unix port. So, for example, when specifying the database server you need to indicate which port it resides on (ex. sybadmin,2004).

Remember that you can only modify tables for which a primary key has been defined or somehow otherwise indicated. In Microsoft Access, this is done at the "Link" table phase for tables which do not have a formally defined primary key.

If you have any questions about the process of implementing any of these ODBC drivers, please contact Mark Rogers at 474-9089 or Mark_Rogers@UManitoba.CA