Netro Support: DSN

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.


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

Set con = Nothing

2. Microsoft SQL Server


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