File Data Sources can not be created with the dbdsn utility. Use the ODBC Administrator to create File Data Sources. System Data Sources are limited to Windows-based operating systems.
Storing user IDs, encrypted or unencrypted passwords, and database keys in a data source is not recommended.
Run a dbdsn command, specifying the connection parameters you want to use.
For example, the following command creates a data source for the sample database. The command must be entered on one line:
dbdsn -w "My DSN" -c "UID=DBA;PWD=sql;DBF=samples-dir\demo.db"
For information about samples-dir, see Samples directory.
For more information about the dbdsn utility, see Data Source utility (dbdsn).
64-bit versions of Windows maintain two sets of the System Data Source collection; one for 64-bit applications and one for 32-bit applications. To create a System Data Source that is accessible to both 64-bit and 32-bit applications, you must run the 32-bit version of dbdsn (located in the SQL Anywhere bin32 folder). To avoid connection problems, set up your 32-bit System Data Source exactly like your 64-bit System Data Source.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|