Access MS database with DSNless connection using ASP???

[warner81]

Hi all,

how can I access MS database with DSNless connnection using ASP?

[Dave]

Like this...


Set Conn = Server.CreateObject("Adodb.Connection")

Then this

DSN=DSN & "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\path\to\database\database.mdb;"

Or this
DSN=DSN & "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("Database.mdb")

Finally, open the connection...
Conn.open DSN
_________________
Any information contained herein is provided in "as is" condition without any guarantee for its accuracy, contains no warrantees - express or implied - and confers no rights.
X1 1.1.4: http://www.aprelium.com/news/abwsx1u1.html