I'm running a news ASP script on my server and I keep getting this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Specified driver could not be loaded due to system error 126 (Microsoft Access Driver (*.mdb)).
/news/Admin.asp, line 87
The code uses Microsoft Jet OLE Provider, and in the past i've only been able to use things with a DBQ= But another provider might work just as well.
As far as I know, it's a Microsoft ISS cold fusion server, but ASP has worked on it before so I know it's installed. I'm just having trouble with it finding the driver as in the error snippet above.
Dim adoCon
Dim strCon
Set adoCon = Server.CreateObject("ADODB.Connection")
strCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("SpawnedDB_nw_db.mdb")
adoCon.Open strCon
thats where I bomb out.
thanks.