Creating an ODBC file data source (ODBC Data Source Administrator)

You can store your ODBC data source information in a file using the ODBC Data Source Administrator.

Prerequisites

To successfully create a file data source, you must be able to establish a connection to the database for which you are creating the file data source.

Context and remarks

Many.

 Create an ODBC file data source (ODBC Data Source Administrator)

  1. Click Start » Programs » SQL Anywhere 12 » Administration Tools » ODBC Data Source Administrator.

  2. Click the File DSN tab.

  3. Click Add.

  4. On the Driver list, click SQL Anywhere 12.

  5. Click Next.

  6. Follow the instructions in the Create New Data Source Wizard.

  7. Click OK.

  8. Click OK.

    Caution

    Storing user IDs, encrypted or unencrypted passwords, and database keys in a data source is not recommended.

Results

The ODBC data source file is created.

Next

None.

Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1