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  )

sofiansafyAsked:
Who is Participating?
 
Dave_GreeneConnect With a Mentor Commented:
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
 
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
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
MCMCommented:
:)
0
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.