Using ODBC data sources on Windows Mobile

Windows Mobile does not provide an ODBC driver manager or an ODBC Administrator. On Windows Mobile, SQL Anywhere uses ODBC data sources stored in files. To use these data source definitions, use either the DSN or the FILEDSN keyword; on Windows Mobile DSN and FILEDSN are synonyms.

Caution

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

Data source location

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

Each data source 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