Solved

CREATERECORDSET (0X80004005) UNSPECIFIED ERROR

Posted on 2001-09-07
1
241 Views
Last Modified: 2008-03-03
Hi,

I have a databse running on SQL server on Machine 1.

When I try to access the ASP which queries this databse from the same machine, I SOMETIMES get the above error. This is resolved by restarting IIS on my machine.

Secondly when i try to access the same from database from Machine 2 on my network I SOMETIMES get the above error while at other times I get (0X80004007)

Any clues as to why this is happening??

I need to automate certain tasks but cannot do so without getting these errors rectified.

Apprecial suggestions at the earliest!

Thanks,
Pranu

0
Comment
Question by:pranu
1 Comment
 
LVL 3

Accepted Solution

by:
phuctran earned 150 total points
ID: 6465680
SYMPTOMS
Within your MDAC 2.0 or MDAC 2.1 code, you have multiple recordsets with the same recordset object that are created off of the same command and are also pointing to the same connection. The first recordset that is opened contains multiple recordsets within that same object. Before calling NextRecordset on that object, open another Recordset (new recordset object) and point the ActiveConnection property to the same command and connection to which at the other recordset object was pointing. This causes the following error when the Set rs = rs.NextRecordset is executed:

error '80004005' Unspecified error
This error occurs in MDAC 2.0 and MDAC 2.1 and does not occur in MDAC 1.5.



RESOLUTION
Make sure that the ActiveConnection property of the Command object for the first recordset is set only once throughout the page (especially if it contains multiple physical recordsets within the same recordset object) if the same connection is still being used.

0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

920 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

14 Experts available now in Live!

Get 1:1 Help Now