February 18th, 2003, 12:21 AM
ASP and MS Access database
i currently have a Ms Access database stored at
how do i use Asp to connect to the database??
I would like to know how to access the database with and without using odbc
February 18th, 2003, 10:46 AM
- Open ODBC data source administrator, which is within control panel->administrative tools on win2k, or c:\winnt\system32
- Use server.mappath, or a physical string
path = "C:\blah\blah.mdb"
'path = "" & Server.MapPath("../database.mdb") & ""
provider = "Microsoft.Jet.OLEdb.4.0"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.provider = provider
objConn.ConnectionString = path
pretty simple stuff.