ASP: COM: ADODB.Connection

Set cn = Server.CreateObject("ADODB.Connection")
---
Set cn = Nothing

cn.Open ConnectionString [, UserID, Password ]

ConnectionString

Three systems are used (one string with parameters are separated with ';'):

driver, dbq:

"driver

{Microsoft Access Driver (*.mdb)}"

"dbq

=
=

G:\InetPub\wwwroot\webdb\coinclub.mdb"
" & Server.MapPath("../webdb/coinclub.mdb")

provider, data source:

"provider

microsoft.jet.oledb.4.0"

"data source

" & server.mappath("afvigelse.mdb")

dsn:

"DSN

=
=

DataSourceName"
Critters"

UserID

"aladdin"

Password

"sesam"

openStr = "driver={Microsoft Access Driver (*.mdb)};" & _
          "dbq=" & Server.MapPath("critters.mdb")
cn.Open openStr

cn.open "provider=microsoft.jet.oledb.4.0;" & _
        "data source=" & server.mappath("afvigelse.mdb")

NB: space/nospace is important!!:

this works		driver={M... dbq=		Microsoft Access Driver (*...
this does NOT work		driver = {M... dbq =		Microsoft Access Driver(*...

>Database: Players

If a Data Source Name (DSN) is used, DSN= is the default parameter:

cn.Open "DSN=Critters"
cn.Open "Critters"

cn.Close