Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • Last Modified:

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  )

0
sofiansafy
Asked:
sofiansafy
  • 4
  • 3
  • 3
1 Solution
 
MCMCommented:
post your code. it should look like:

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

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

MCM and I would recommend 2.6 with SP1  :)
0
 
MCMCommented:
:)
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
sofiansafyAuthor Commented:
MCM
my code is already like your code , and the error
is still occure..
0
 
MCMCommented:
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.
0
 
sofiansafyAuthor Commented:
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
0
 
Dave_GreeneCommented:
Let me double check...
0
 
Dave_GreeneCommented:
If you were running 2000 or better I would recommend 2.6 SP1 But since you are on '97 I would suggest 2.5 SP2.  I has full support for the Jet 3.0 engine (97 release)

Here is the link
http://www.microsoft.com/data/download.htm#252info

Let us know how it goes.

Dave
0
 
sofiansafyAuthor Commented:
I don't know how to thank u Dave , its really solve the problem .....

My thanks also to MCM for his care...


Sofian
0
 
Dave_GreeneCommented:
You're welcome, glad we could help!

Cya round
Dave
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 4
  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now