How to create a connection to DB without a DSN 1

[rewdee]

If I can't get the web host to set up a DSN for my web page, How do I create a connection to my database using ADO?
(I do know its relative path to the db).

Thanks,
Rewdee

 

[vasah20]

Dim c
set c = Server.CreateObject("ADODB.Connection&quot
'TODO: change directory when locally testing
c.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("yourdbname.mdb&quot

you can change the server.mappath to the fully qualified path to your DB, if you'd like leo

------------
Leo Mendoza
lmendoza@garbersoft.net