DataSourceName Connection Parameter [DSN]

Tells the ODBC driver manager or Embedded SQL library where to look in the .odbc.ini file (on UNIX), or odbc.ini file or registry (on Windows), to find ODBC data source information.

Usage

Anywhere

Default

None

Description

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 SAP Sybase IQ, Embedded SQL applications can also use ODBC data sources to store connection parameters.

Example

This parameter uses a data source name:

DSN=Dynamo Demo