Table of ContentsPreviousNext

Ispirer             Ispirer

Ispirer SQLWays Database Migration Software

System 11 ODBC Driver

Configuring the ODBC DSN

The 11.x version of the ODBC driver for ASE has a name that is not exactly intuitive. It is called 'Sybase System 11.' This driver is compatible with Open Client 10.x and 11.1.1, SQL Server 10.x, ASE 11.5, ASE 11.9.2 and ASE 12.0.

This driver works with the Sybase Open Client protocol to make its ODBC connection. Therefore, you must specify the name of the ASE server in the Server Name field of the ODBC DSN definition as it is defined to Open Client in the sql.ini file. The following picture shows its General tab.

The information it contains is as follows:

Data Source Name =the arbitrary name you assign for your ASE ODBC DSN. This is a required field.

Description =any descriptive information you want to provide about the DSN. This is an optional field.

Server Name =the server name for ASE as it is defined to Open Client in the sql.ini file. This is a required field.

Database Name =the name of the specific ASE database to which you want the ODBC DSN to connect (In the picture, this is blank). This is an optional field. If you leave the Database Name field blank, the driver will connect by default to the Master database.

Testing the Connection

The Sybase System 11 driver configuration does not provide a connection test feature. To test connectivity for ODBC DSNs defined with this driver, you must try them with an ODBC application. If you have ODBC Test, which is provided with the Microsoft SDK, you can use it to verify connectivity to ASE.

Table of ContentsPreviousNext
Ispirer             Ispirer
Copyright © 1999-2015 Ispirer Systems Ltd. Ispirer and SQLWays are trademarks of Ispirer Systems Ltd. All other product names may be trademarks of the respective companies. All rights reserved.