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

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.

Create an ODBC data source with the dbdsn utility

Caution

To create an ODBC data source (command line)

Creating a System ODBC data source on 64-bit Windows

See also