Hi,
 
Kindly I am getting the following error while attempting to create a
ADODB.Recordset, the following is my code:
 
<% 
  
  dim Con
  dim Rec
  dim strSQL
 
  Set Con=Server.CreateObject("ADODB.Connection")
  Con.Open strCon       ' strCon is DNS connection string defined in
included file
 
  strSQL="SELECT * FROM anyTable"
 
  Set Rec=Server.CreateObject("ADODB.Recordset")
  Rec.Open strSQL, strCon, adOpenDynamic
  ...
  ...
 
 Rec.Close
 Set Rec=Nothing    %>
 
 The Problem: I am getting the forementioned error '800A01AD'  "ActiveX
component can't create object.
 I tried to solve it by including 'adovbs.inc' file, and 
 by using METADATA TYPE   to refer to 'msado15.dll'  library file. But it
didn't work!
 
 I am using the PWS web server.
 
 Any support is highly appreciated,
 Thanks. 
   

Seems to me that u might be having a corrupt version of MDAC. Try the
following:

1.	Install the latest version and any service packs currently out
(I'd try 2.6)
2.	Make sure that the IUSR_computer and IWAM_computer users have
read rights to the <drive letter>:\Program Files\Common Files\System\ADO
directory

Hope it helps ...

Rodney

-----Original Message-----
From: asalahi [mailto:asalahi@a...]
Sent: Monday, March 17, 2003 1:06 PM
To: Access ASP
Subject: [access_asp] Encountering error #'800A01AD'

Hi,

Kindly I am getting the following error while attempting to create a
ADODB.Recordset, the following is my code:

<%
 
  dim Con
  dim Rec
  dim strSQL

  Set Con=3DServer.CreateObject("ADODB.Connection")
  Con.Open strCon       ' strCon is DNS connection string defined in
included file

  strSQL=3D"SELECT * FROM anyTable"

  Set Rec=3DServer.CreateObject("ADODB.Recordset")
  Rec.Open strSQL, strCon, adOpenDynamic
  ...
  ...

 Rec.Close
 Set Rec=3DNothing    %>

 The Problem: I am getting the forementioned error '800A01AD'  "ActiveX
component can't create object.
 I tried to solve it by including 'adovbs.inc' file, and
 by using METADATA TYPE   to refer to 'msado15.dll'  library file. But
it
didn't work!

 I am using the PWS web server.

 Any support is highly appreciated,
 Thanks.