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.
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.
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
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|