• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1481
  • Last Modified:

CreateRecordset error '80041820' - Need Solution

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
johnson00
Asked:
johnson00
  • 2
  • 2
  • 2
  • +1
1 Solution
 
WhisperUKCommented:
0
 
peh803Commented:
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
 
johnson00Author Commented:
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
sybeCommented:
>> What service is this error referencing?

to Microsoft Indexserver
0
 
johnson00Author Commented:
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
 
peh803Commented:
@johnson00 -- sorry I could help further...  Good luck!

peh803
0
 
WhisperUKCommented:
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
 
sybeCommented:
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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now