Configuring a datasource

You can configure the Adaptive Server ODBC Driver using the iODBC Administrator.

StepsConfiguring a datasource

  1. Start the iODBC Administrator from Applications | Utilities.

  2. Select the User DSN tab. The Choose a Driver window opens.

  3. Select the Adaptive Server Enterprise Driver you want to use.

  4. Click OK.

  5. Provide a name for your datasource in the Data Source Name (DSN) field.

  6. Provide a description for your datasource in the Description field.

  7. Click Add to add keyword value pairs. Repeat this step until you have added all the keyword value pairs. For example:

    Keyword     Value
    UserID      sa
    Password
    Server     sampleserver
    Port       4100
    Database   pubs2
    UseCursor   1
    
  8. Click OK to save the changes.

NoteFor more information on installing and configuring drivers and datasources using the iODBC Administrator on Apple Mac OS X, look up the iODBC Administrator online help.