Using ODBC Data Source Names (DSN)

An ODBC Data Source Name (DSN) is a symbolic name that represents an ODBC connection and is used to provide connectivity to a database through an ODBC driver. A DSN stores the connection details such as database name, database driver, user identifier, password, and so on, saving you the trouble of having to remember and specify all the details when making a connection. While ODBC applications can access the database directly and do not necessarily require a connection through a DSN, using an ODBC DSN is preferred because of its transparency, flexibility, and ease of use. Once you create an ODBC DSN you can reference it in your application to retrieve data from the database.

Depending on the requirements of your ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.