Contents Index Using ODBC data sources on UNIX Connecting from desktop applications to a Windows CE database

ASA Database Administration Guide
  Connecting to a Database
    Working with ODBC data sources

Using ODBC data sources on Windows CE


Windows CE does not provide an ODBC driver manager or an ODBC Administrator. On this platform, Adaptive Server Anywhere uses ODBC data sources stored in files. You can specify either the DSN or the FILEDSN keyword to use these data source definitions—on Windows CE (only), DSN and FILEDSN are synonyms.

Data source location 

Windows CE searches for the data source files in the following locations:

  1. The directory from which the ODBC driver (dbodbc9.dll ) was loaded. This is usually the Windows directory.

  2. The directory specified in Location key of the Adaptive Server Anywhere section of the registry. This is usually the same as the Adaptive Server Anywhere installation directory. The default installation directory is:

    \Program Files\Sybase\ASA

Each data source itself is held in a file. The file has the same name as the data source, with an extension of .dsn.

For more information about file data sources, see Using file data sources on Windows.


Contents Index Using ODBC data sources on UNIX Connecting from desktop applications to a Windows CE database