O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required