To configure a Data Source
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 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”.
