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

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » SQL Anywhere database connections » Creating ODBC data sources

 

Create ODBC data sources using the ODBC Administrator

Use the Microsoft ODBC Administrator to create and edit data sources on Windows-based applications. Use the utility to work with User Data Sources, File Data Sources, and System Data Sources.

Caution

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

♦  To create an ODBC data source (ODBC Administrator)
  1. Choose Start » Programs » SQL Anywhere 11 » ODBC Administrator.

  2. To create an ODBC data source for the current user, click the User DSN tab.

    To create a system-wide ODBC data source, click the System DSN tab.

  3. Click Add.

  4. In the Name list, choose SQL Anywhere 11. Click Finish.

  5. Specify the connection parameters for the ODBC data source.

  6. Click OK.

  7. Click OK.

Creating a System ODBC data source on 64-bit Windows

64-bit versions of Windows maintain two sets of the System Data Source collection; one for 64-bit applications and one for 32-bit applications. To create a System Data Source that is accessible to both 64-bit and 32-bit applications, you must run a copy of the 32-bit ODBC Administrator (located in the WINDOWS\SysWOW64 folder). To avoid connection problems, set up your 32-bit System Data Source exactly like your 64-bit System Data Source.

♦  To edit an ODBC data source using the ODBC Administrator
  1. Choose Start » Programs » SQL Anywhere 11 » ODBC Administrator.

  2. Click the User DSN tab.

  3. In the Name list, click a data source.

  4. Click Configure.

  5. Edit the connection parameters for the ODBC data source.

  6. Click OK.

  7. Click OK.