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.

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.