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

Connecting from SQL Anywhere utilities Next Page

Working with ODBC data sources


Microsoft defines the Open Database Connectivity (ODBC) interface, which is a standard interface for connecting client applications to database management systems in the Windows environments. Many client applications, including application development systems, use the ODBC interface to access a wide range of database systems.

The SQL Anywhere ODBC driver is named dbodbc10.dll, and it is located in install-dir\win32.

For more information about using SQL Anywhere with ODBC, see ODBC conformance.

You can use ODBC data sources to connect to SQL Anywhere databases from any of the following applications:

Where data sources are held

You connect to an ODBC database using an ODBC data source. You need an ODBC data source on the client computer for each database you want to connect to.

The ODBC data source contains a set of connection parameters. You can store sets of SQL Anywhere connection parameters as an ODBC data source, in either the Windows registry or as files.

If you have a data source, your connection string can simply name the data source to use:

For SQL Anywhere, the use of ODBC data sources goes beyond Windows applications using the ODBC interface:

Note

When creating a connection string, it can contain the name of an ODBC data source that contains connection parameters, as well as connection parameters that are specified explicitly. If a connection parameter is specified in the connection string as well as in the ODBC data source, the value that is specified explicitly takes precedence.


Creating an ODBC data source
Creating ODBC data sources using the ODBC Administrator
Creating an ODBC data source from the command line
Creating an ODBC data source on Mac OS X
Using file data sources on Windows
Using ODBC data sources on Windows CE
Using ODBC data sources on Unix