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.

Caution

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.

A sample Windows Mobile data source

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

[ODBC]
DRIVER=\windows\dbodbc11.dll
UID=DBA
PWD=sql
Integrated=No
AutoStop=Yes
ServerName=SalesDB_remote
LINKS=tcpip(host=192.168.0.55;port=2638;dobroadcast=none)
LOG=\sa_connection.txt
START=dbsrv11 -c 8M