Link to home
Start Free TrialLog in
Avatar of sofiansafy
sofiansafy

asked on

Recordset error message

I have this error message when I try to create a Recordset

( Microsoft VBScript runtime error '800a01ad'
  ActiveX component can't create object  )

Avatar of MCM
MCM

post your code. it should look like:

set rs = Server.CreateObject("ADODB.RecordSet")
You may not have MDAC installed.

http://www.microsoft.com/data/download.htm

MCM and I would recommend 2.6 with SP1  :)
:)
Avatar of sofiansafy

ASKER

MCM
my code is already like your code , and the error
is still occure..
can you make other ADODB objects, such as a Connection? i would try installing the latest MDAC, as Dave suggested, and giving it another go.
MCM
Yes I can make a Connection, the problem is with Recordset
....
Dave
I using Microsoft Access97 as a Database(Not SQL200) ,so is MDAC 2.6 SP1 is suitable for me.

Thanks
Let me double check...
ASKER CERTIFIED SOLUTION
Avatar of Dave_Greene
Dave_Greene

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I don't know how to thank u Dave , its really solve the problem .....

My thanks also to MCM for his care...


Sofian
You're welcome, glad we could help!

Cya round
Dave