Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - Database Administration » Starting and connecting to your database » SQL Anywhere database connections » Creating ODBC data sources

 

Create an ODBC data source with the dbdsn utility

File Data Sources can not be created with the dbdsn utility. Use the ODBC Data Source Administrator to create File Data Sources. System Data Sources are limited to Windows-based operating systems.

Caution

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

 To create an ODBC data source (command line)
  • 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 "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).

 Creating a System ODBC data source on 64-bit Windows
 See also