Overview
A DSN (Data Source Name) provides connectivity to a database,
such as a Microsoft Access mdb (Microsoft Database).
Connectionless DSN are easier to setup, since they do not require provisioning
by a system administrator
and provide faster database access, since uses native OLE DB (Object Linking
& Embedding Database) providers, instead
of ODBC (Open Database Connectivity) drivers.
Microsoft
JET Database Engine (Joint Engine Technology) is the
underlying database component of a Microsoft Access Database.
Examples
1. Microsoft Access
<%
Dim con
Set con = Server.CreateObject("ADODB.Connection")
con.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\inetpub\siteid\database\siteid.mdb"
' Now database is open and we are connected
' Do some thing here
' We are done so lets close the connection
con.Close
Set con = Nothing
%>
2. Microsoft SQL Server
Links
Connection String
Home Page examples:
- OLE DB Provider
for Microsoft Jet
-
OLE DB Provider for SQL Server
-
ODBC Driver for Access
-
ODBC Driver for SQL Server
MSDN Data Home Page
Microsoft
Jet Database Engine
Microsoft Data Access Components
adovbs.inc