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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » SQL Anywhere database connections » 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.

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

Caution

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

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

  2. Click the File DSN tab.

  3. Click Add.

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

  5. Click Next.

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

  7. Click OK.

  8. Click OK.

Results

The ODBC data source file is created.