How do I connect to my MS Access database?
Make sure your database is in the "db" directory in your file space.
Here is a sample ASP code to connect to a MS Access database.
Dim Conn
Set Conn = Server.CreateObject("ADODB.Connection")
strConnection = "DRIVER=Microsoft Access Driver(*.mdb);DBQ=" & Server.MapPath("/USERNAME/db/yourdatabase.mdb")
oConn.Open(strConnection)
....
...
oConn.Close
so please how i can use this mode to connect to my database
remove the ' on line 55 of config.asp strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 97 on Brinkster
Topic Locked
Posted - 09 September 2007 : 21:42:20
