Difference between revisions of "Data Source Name - DSN"
PeterHarding (talk | contribs) (New page: =Windows= Short for Data Source Name. Data Source Name provides connectivity to a database through an ODBC driver. The DSN contains database name, directory, database driver, UserID, pass...) |
PeterHarding (talk | contribs) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 9: | Line 9: | ||
# File DSN -- DSN info is stored in a text file with .DSN extension. | # File DSN -- DSN info is stored in a text file with .DSN extension. | ||
DSN is often used by Active Server Pages (ASP) and Visual Basic programs when a query to a database is necessary to retrieve information. | DSN is used by SQL client to establish connections. It is also often used by Active Server Pages (ASP) and Visual Basic programs when a query to a database is necessary to retrieve information. | ||
There is also what is known as a "DSN-less connection." Instead of using a DSN to connect to a database, the developer specifies the necessary information right in the application. With a DSN-less connection the developer is free to use connection standards other than ODBC, such as OLE DB. | There is also what is known as a "DSN-less connection." Instead of using a DSN to connect to a database, the developer specifies the necessary information right in the application. With a DSN-less connection the developer is free to use connection standards other than ODBC, such as OLE DB. | ||
[[Category:Database]] | |||
Latest revision as of 19:09, 28 April 2008
Windows
Short for Data Source Name. Data Source Name provides connectivity to a database through an ODBC driver. The DSN contains database name, directory, database driver, UserID, password, and other information. Once you create a DSN for a particular database, you can use the DSN in an application to call information from the database.
There are three types of DSNs:
- System DSN -- can be used by anyone who has access to the machine. DSN info is stored in the registry.
- User DSN -- created for a specific user. Also stored in the registry.
- File DSN -- DSN info is stored in a text file with .DSN extension.
DSN is used by SQL client to establish connections. It is also often used by Active Server Pages (ASP) and Visual Basic programs when a query to a database is necessary to retrieve information.
There is also what is known as a "DSN-less connection." Instead of using a DSN to connect to a database, the developer specifies the necessary information right in the application. With a DSN-less connection the developer is free to use connection standards other than ODBC, such as OLE DB.