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

SQL Anywhere 11.0.1 » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » SQL Anywhere database connections » Creating ODBC data sources


Create an ODBC data source with the dbdsn utility

File Data Sources can not be created with the dbdsn utility. Use the ODBC Administrator to create File Data Sources. System Data Sources are limited to Windows-based operating systems.


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

To create an ODBC data source (Command line)

For more information about the dbdsn utility, see Data Source utility (dbdsn).

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 the 32-bit version of dbdsn (located in the SQL Anywhere bin32 folder). To avoid connection problems, set up your 32-bit System Data Source exactly like your 64-bit System Data Source.