Regularly when I'm testing my ASP pages on Win98 with Personal Web Server 4 I get this error:
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.Code:Microsoft VBScript runtime error '800a01ad' ActiveX component can't create object /workmenu.asp, line 29
This is the code that created the above error message:
It was actually the second line of that code that caused the error.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
Does anyone know why this happens?


Reply With Quote