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 data source (ODBC Data Source Administrator)

To create an ODBC data source, you can use the ODBC Data Source Administrator.

Prerequisites

There are no prerequisites for this task.

Context and remarks

On Windows, system data sources are available to all users of the computer system and to Windows services. User data sources are available only to the user for which it was created.

Note
  • Creating a system data source on 64-bit Windows   System data sources are available to all users of the computer system and to Windows services. 64-bit versions of Windows maintain two sets of system data sources in the Windows Registry: one for 64-bit client applications and one for 32-bit client applications. To create a system data source that is accessible to 32-bit applications, you must run the 32-bit ODBC Data Source Administrator (located in the %windir%\syswow64 folder). To avoid connection problems, it is recommended that you create both 64-bit and 32-bit system data sources and ensure that they are configured identically.

  • Creating a user data source on 64-bit Windows   User data source definitions are stored in the part of the Windows Registry containing settings for the user currently logged on to the system. 64-bit versions of Windows maintain one set of user data sources in the Windows Registry for each user of the computer. You can use either the 32-bit or the 64-bit version of the ODBC Data Source Administrator to create a user data source. This data source can be used by both 64-bit and 32-bit client applications as long as the matching ODBC driver is installed.

 Task
  1. For the 32-bit ODBC Data Source Administrator, click Start » Programs » SQL Anywhere 16 » Administration Tools » ODBC Data Source Administrator (32-bit).

    For the 64-bit ODBC Data Source Administrator, click Start » Programs » SQL Anywhere 16 » Administration Tools » ODBC Data Source Administrator (64-bit).

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

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

  3. Click Add.

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

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

    Caution

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

  6. Click OK.

  7. Click OK.

Results

The ODBC data source is created.

 See also