Data Source Name - DSN - Revision history

PeterHarding at 08:09, 28 April 2008

2008-04-28T08:09:18Z

← Older revision		Revision as of 18:09, 28 April 2008
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]]		[[Category:Database]]

PeterHarding at 08:08, 28 April 2008

2008-04-28T08:08:21Z

← Older revision		Revision as of 18:08, 28 April 2008
Line 12:		Line 12:

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

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

2008-04-28T08:07:59Z

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

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