PWS 4 can't create "ADODB.Connection" Object
Regularly when I'm testing my ASP pages on Win98 with Personal Web Server 4 I get this error:
Code:
Microsoft VBScript runtime error '800a01ad'
ActiveX component can't create object
/workmenu.asp, line 29
when I try to create an instance of the "ADODB.Connection" object. If I test the page on a Win2K or NT4 server the code works fine. I've also found that the error doesn't always occur. For instance I have a page that simply writes a "log" record to a database and that works fine...other times when I try do do something simpler...like just read from the database I get the error.
This is the code that created the above error message:
Code:
dim oConn, oRSCat, oRSWork
set oConn = Server.CreateObject("ADODB.Connection")
oConn.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)};"
oConn.ConnectionString = oConn.ConnectionString & "DBQ=" & Server.MapPath("datastore.mdb") & ";"
oConn.ConnectionString = oConn.ConnectionString & "PWD=" & sDBPassword
oConn.Open
It was actually the second line of that code that caused the error.
Does anyone know why this happens?
