Configuring a Datasource

Set up a datasource.

1. Launch the ODBC Administrator.
   See the online help for your specific Microsoft Windows operating system for detailed instructions.
2. Select the User DSN tab. Click Add.
3. Choose Adaptive Server Enterprise from the list of drivers.
4. Click Finish.
5. Select the General tab and enter values for these fields:

   • Data Source Name – a name for your datasource

   • Description – a description for your datasource

   • 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 log in to the Adaptive Server Enterprise database

6. Select Use Cursors to open cursors for every select statement.
7. Complete the Connection and Advanced tabs as needed.
8. Click OK to save the changes.