Solved

CreateRecordset error '80041820' - Need Solution

Posted on 2004-10-15
8
1,451 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 250 total points
Comment Utility
0
 
LVL 19

Expert Comment

by:peh803
Comment Utility
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
Comment Utility
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
 
LVL 28

Expert Comment

by:sybe
Comment Utility
>> What service is this error referencing?

to Microsoft Indexserver
0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 2

Author Comment

by:johnson00
Comment Utility
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
Comment Utility
@johnson00 -- sorry I could help further...  Good luck!

peh803
0
 
LVL 3

Expert Comment

by:WhisperUK
Comment Utility
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
Comment Utility
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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

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/…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

763 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now