May 27th, 2000, 05:45 PM
Regularly when I'm testing my ASP pages on Win98 with Personal Web Server 4 I get this error:
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:
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?
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:
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?