[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

CreateRecordset error '80041820' - Need Solution

Posted on 2004-10-15
8
Medium Priority
?
1,475 Views
Last Modified: 2008-01-09
At the following line in my code:

Set rsQuery = objQuery.CreateRecordset("nonsequential")

I receive the following error:

CreateRecordset error '80041820'
Service is not running.

What service is this error referencing?
0
Comment
Question by:johnson00
  • 2
  • 2
  • 2
  • +1
8 Comments
 
LVL 3

Accepted Solution

by:
WhisperUK earned 1000 total points
ID: 12319069
0
 
LVL 19

Expert Comment

by:peh803
ID: 12319103
I've not used objQuery.CreateRecordset before...

Have you tried this?
  set rsQuery = server.createobject("ADODB.Recordset")

Excuse me if you already know this or if it's not what you want, but this creates an adodb recordset which you can use to do all kinds of great stuff....

More on adodb recordset object here:

http://www.w3schools.com/ado/ado_ref_recordset.asp

HTH,
peh803
0
 
LVL 2

Author Comment

by:johnson00
ID: 12319186
peh -

unfortunately, I'm left managing code that's been written by someone else.  I haven't had a chance to rewrite all old functions, as I'm busy trying to create new functions.  This is a process that has been working in the past, and I believe the issue may be server related, as whisper has implied.

I appreciate the information on the recordset though.  I'm a novice at this stuff and can use all the resources I can get!

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!

 
LVL 28

Expert Comment

by:sybe
ID: 12319194
>> What service is this error referencing?

to Microsoft Indexserver
0
 
LVL 2

Author Comment

by:johnson00
ID: 12319196
Whisper -

Thanks for the suggestion.  I searched for that type of information before posting and didn't have any luck.  I have a call into the server administrator to check into whether or not indexing service is up and running.  That's the type of suggestion I was looking for though!

Stay tuned!
0
 
LVL 19

Expert Comment

by:peh803
ID: 12319217
@johnson00 -- sorry I could help further...  Good luck!

peh803
0
 
LVL 3

Expert Comment

by:WhisperUK
ID: 12319277
ah it was just a hunch so I went to M$ site to have a look. If that turns out to be your problem then it was a lucky guess on my part  :-D
0
 
LVL 28

Expert Comment

by:sybe
ID: 12319295
read this for more information about how to work with index server in ASP:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnproasp2/html/integratingmicrosoftindexserver.asp
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

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 informatio…
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/…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses

834 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