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.

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 "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).

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.