DataSourceName connection parameter [DSN]

Function

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

There is no default data source name.

See also

“FileDataSourceName connection parameter [FileDSN]”

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

Example

The following parameter uses a data source name:

DSN=Dynamo Demo