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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Connecting to a Database » Working with ODBC data sources

Creating ODBC data sources using the ODBC Administrator Next Page

Creating an ODBC data source from the command line

You can create User and System Data Sources using the dbdsn utility. You can not create File Data Sources in this way. System Data Sources are limited to Windows operating systems only, and you can use the ODBC Administrator to create File Data Sources.

To create an ODBC data source (Command line)
  1. Open a command prompt.

  2. Enter 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" "UID=DBA;PWD=sql;DBF=samples-dir\demo.db"

    For information about samples-dir, see Samples directory.

  3. For more information on the dbdsn utility, see Data Source utility (dbdsn).