Re: Provider (0x80004005)
Since you're using ADO I would use my connection as follows:
VB Code:
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.