Provider (0x80004005)

[Guru]

Page loads ok but if I refresh it I get the following error:

Provider (0x80004005)
Unspecified error

The error is in the conn.open line

set Conn = Server.CreateObject("ADODB.Connection")

Conn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath("\abc\abc.mdb"))

WHY?


access 97 db
running on IIS on XP



Thanks

[Mr.No]

Since you're using ADO I would use my connection as follows:

set Conn = Server.CreateObject("ADODB.Connection")
 lcStrDB = "c:\db\abc.mdb"
 set Conn = Server.CreateObject("ADODB.Connection")
 
Conn.Open("Provider=Microsoft.OLEDB.Jet.4.0;Data Source=" & lcStrDB ";User ID=admin;password=;")

I'm not sure if the statement server.MapPath("\abc\abc.mdb")) is correct. I think Server.MapPath returns the folder location of the file only so you'll have to explicitly concatenate the mdb name to the return value.