Solved

Recordset error message

Posted on 2001-08-29
10
213 Views
Last Modified: 2008-03-10
I have this error message when I try to create a Recordset

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

0
Comment
Question by:sofiansafy
  • 4
  • 3
  • 3
10 Comments
 
LVL 2

Expert Comment

by:MCM
ID: 6437924
post your code. it should look like:

set rs = Server.CreateObject("ADODB.RecordSet")
0
 
LVL 8

Expert Comment

by:Dave_Greene
ID: 6437998
You may not have MDAC installed.

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

MCM and I would recommend 2.6 with SP1  :)
0
 
LVL 2

Expert Comment

by:MCM
ID: 6438044
:)
0
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 

Author Comment

by:sofiansafy
ID: 6442820
MCM
my code is already like your code , and the error
is still occure..
0
 
LVL 2

Expert Comment

by:MCM
ID: 6442834
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
 

Author Comment

by:sofiansafy
ID: 6443037
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
 
LVL 8

Expert Comment

by:Dave_Greene
ID: 6443042
Let me double check...
0
 
LVL 8

Accepted Solution

by:
Dave_Greene earned 100 total points
ID: 6443051
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
 

Author Comment

by:sofiansafy
ID: 6444726
I don't know how to thank u Dave , its really solve the problem .....

My thanks also to MCM for his care...


Sofian
0
 
LVL 8

Expert Comment

by:Dave_Greene
ID: 6445163
You're welcome, glad we could help!

Cya round
Dave
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Need to rewrite code for checking if a file exists 3 69
Using Classic ASP inside HTML pages 2 62
If-Then-Else ASP problem 6 67
Set time on Session (ASP) 14 22
I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question