|
|
Ispirer SQLWays Database Migration Software
ASE 12 ODBC Driver
Configuring the ODBC DSN
The ASE ODBC Driver, which is new with ASE version 12, allows you to specify all the information you need on the General tab. It also now provides a connection test feature, so you can test the connection from within the driver configuration utility.
This driver is compatible with Open Client version 12.0 and ASE version 12, as well as ASE 11.9.2. You cannot use the driver with Open Client 11.1.1. If you attempt to configure a DSN using a server defined with Open Client 11.1.1, you will see that you can configure the DSN and run the Test Connect utility successfully. However, you will not be able to save the DSN and/or exit the driver configuration utility.
This ASE ODBC driver works with Open Client version 12.0 to make an ODBC connection. Therefore, you must specify the ASE server name as it is defined to Open Client in the sql.ini file in the Server name field of the ODBC DSN. The following image shows the General tab from the ASE driver configuration.
It contains the following information:
Data Source Name =the arbitrary name you assign for your ASE ODBC DSN. This is a required field.
Description =(blank in this picture) 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. This is an optional field. You can specify a database on this tab, or on the logon screen, or not at all, in which case you are connected by default to the Master database.
Testing the Connection
Use the Test Connect button to verify connectivity before you exit the driver configuration utility.
|
|
