Launch the ODBC Administrator. See the online help for your specific Windows operating system for detailed instructions.
Select the User DSN tab. Click Add.
Choose “Adaptive Server Enterprise” from the list of drivers.
Click Finish.
Select the General tab. Enter values in the following fields:
Data Source Name: a name for your data source
Description: a description for your data source
Server Name: an Adaptive Server Enterprise host name
Server Port: an Adaptive Server Enterprise port number
Database Name: a database name
Logon ID: a user name to login to the Adaptive Server Enterprise database
Select Use Cursors if you want cursors to be opened for every select statement.
Complete the Connection and Advanced tabs as needed.
Click OK to save the changes.
For a detailed explanation of connection parameters,
see “Using connection parameters”.
To configure a data source