|
|
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.
|
|
