Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Starting and connecting to your database » SQL Anywhere database connections » ODBC data sources


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.


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


 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.


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


The ODBC data source file is created.