ASP and MS access database

[kinsley]

I currently have a Ms Access database stored at
c:\database\db.mdb

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
Any ideas are welcomed
Thanks -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[cameroon]

With ODBC
- Open ODBC data source administrator, which is within control panel->administrative tools on win2k, or c:\winnt\system32

Without ODBC
- Use server.mappath, or a physical string

Like this.
PHP Code:
dim path
dim provider

path = "C:\blah\blah.mdb"
'path = "" & Server.MapPath("../database.mdb") & ""
provider = "Microsoft.Jet.OLEdb.4.0"

dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.provider = provider
objConn.ConnectionString = path
objConn.Open

Hope taht helps -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --