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 (dbdsn utility)

To create an ODBC data source, use the dbdsn utility.

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. File data sources cannot be created with the dbdsn utility. Use the ODBC Data Source Administrator to create file data sources.

On Linux and other non-Windows systems, the dbdsn utility can be used to create ODBC data sources.

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 dbdsn utility (located in the bin32 subdirectory of your SQL Anywhere installation directory). 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 dbdsn utility 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.

Caution

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

 Task
  • Run the Data Source utility (dbdsn) from a command prompt.

Results

The ODBC data source is created.

Example

The following command creates an ODBC data source for the sample database. The command must be entered on one line:

dbdsn -w "My DSN" -c "DBF=$SQLANY16/demo.db;"

 See also