To create an ODBC data source, use the dbdsn utility.
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.
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.
Storing user IDs, encrypted or unencrypted passwords, and database keys in a data source is not recommended.
Run the Data Source utility (dbdsn) from a command prompt.
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;"
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|