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.
Storing user IDs, passwords (encrypted or unencrypted), and/or database keys in a data source is not secure. It is recommended that you do not store this information in a data source if the database contains sensitive data.
The SQL Anywhere ODBC driver is named dbodbc11.dll, and it is located in install-dir\bin32.
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:
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:
Data source Use the DataSourceName (DSN) connection parameter to reference a data source in the Windows registry:
File data source Use the FileDataSourceName (FILEDSN) connection parameter to reference a data source held in a file:
For SQL Anywhere, the use of ODBC data sources goes beyond Windows applications using the ODBC interface:
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
Generating ODBC data sources using the Connect window
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 Mobile
Using ODBC data sources on Unix
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|