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

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » Connecting to a database » Working with ODBC data sources


Using ODBC data sources on Windows Mobile

Windows Mobile does not provide an ODBC driver manager or an ODBC Administrator. On this platform, SQL Anywhere uses ODBC data sources stored in files. You can specify either the DSN or the FILEDSN keyword to use these data source definitions—on Windows Mobile (only), DSN and FILEDSN are synonyms.


Storing user IDs, passwords (encrypted or unencrypted), and/or database keys in a data source is not secure. It is recommended that you do not store this information in a data source if the database contains sensitive data.

Data source location

Windows Mobile searches for the data source files in the root directory of the device: \filename.dsn.

Each data source itself is held in a file. The file has the same name as the data source, with an extension of .dsn.

See also
A sample Windows Mobile data source

The following is a sample of an ODBC data source for Windows Mobile.

START=dbsrv11 -c 8M
See also