SQL Anywhere® Server - Database Administration  > Connecting to a Database  > Working with ODBC data sources

Using ODBC data sources on Windows CE

Windows CE 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 CE (only), DSN and FILEDSN are synonyms.

Windows CE 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.

• Using file data sources on Windows

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

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

• Creating an ODBC data source to connect to your Windows CE device