Tells the ODBC driver manager or embedded SQL library where to look in the registry or the system information file (named .odbc.ini by default) to find ODBC data source information.

Usage

Anywhere

Values

String

Default

There is no default data source name.

Remarks

It is common practice for ODBC applications to send only a data source name to ODBC. The ODBC driver manager and ODBC driver locate the data source, which contains the remainder of the connection parameters.

In SQL Anywhere, embedded SQL applications can also use ODBC data sources to store connection parameters.

See also

• FileDataSourceName connection parameter [FILEDSN]
• Connection parameters
• Resolving connection parameter conflicts
• Using ODBC data sources on Unix
• Creating ODBC data sources

Example

The following parameter uses a data source name:

DSN=My Database