E_Fail Status with VB6

Have a VB6 app that is being used to pull data from a database. 
Various locations have this database and it has been running
fine on all of them except for one where we are getting  the following 
error message:

"the data provider or other service returned an E_FAIL status"

The connection string for the ADO connection looks like this:

Provider=SQLOLEDB;Password=MyPassword;Persist Security Info=True;User 
ID=MyUser;Initial Catalog=MyDB;Data Source=MyServer

The recordset is using adUseClient, adOpenForwardOnly, 
adLockBatchOptimistic

The select statement is a simple Select * from table

Only the statement query analyzer returns all of the expected records, 
just errors out on one database, which
said application having been tried on 3 different computers.

Any ideas?



0
Nobody
9/9/2010 5:18:12 PM
vb.general.discussion 1016 articles. 0 followers. Follow

14 Replies
3797 Views

Similar Articles

[PageSpeed] 6

No idea.


"Nobody" <trinity@nobody.com> wrote in message 
news:i6b4sm$8nv$1@news.eternal-september.org...
> Have a VB6 app that is being used to pull data from a database. Various 
> locations have this database and it has been running
> fine on all of them except for one where we are getting  the following 
> error message:
>
> "the data provider or other service returned an E_FAIL status"
>
> The connection string for the ADO connection looks like this:
>
> Provider=SQLOLEDB;Password=MyPassword;Persist Security Info=True;User 
> ID=MyUser;Initial Catalog=MyDB;Data Source=MyServer
>
> The recordset is using adUseClient, adOpenForwardOnly, 
> adLockBatchOptimistic
>
> The select statement is a simple Select * from table
>
> Only the statement query analyzer returns all of the expected records, 
> just errors out on one database, which
> said application having been tried on 3 different computers.
>
> Any ideas?
>
>
> 


0
Phil
9/9/2010 5:52:30 PM
On Thu, 9 Sep 2010 13:18:12 -0400, "Nobody" <trinity@nobody.com>
wrote:

>Have a VB6 app that is being used to pull data from a database. 
>Various locations have this database and it has been running
>fine on all of them except for one where we are getting  the following 
>error message:
>
>"the data provider or other service returned an E_FAIL status"
>
>The connection string for the ADO connection looks like this:
>
>Provider=SQLOLEDB;Password=MyPassword;Persist Security Info=True;User 
>ID=MyUser;Initial Catalog=MyDB;Data Source=MyServer
>
>The recordset is using adUseClient, adOpenForwardOnly, 
>adLockBatchOptimistic
>
>The select statement is a simple Select * from table
>
>Only the statement query analyzer returns all of the expected records, 
>just errors out on one database, which
>said application having been tried on 3 different computers.
>

That is a particularly nasty error as it is the ultimate "bail-out"
for a client of a COM component. ie, a call failed and there was no
other information or it returned an error that VB or ADO couldn't
categorize as anything else. And it could be coming from anything from
the DAC/MDAC components on down.

Your best bet is to use a JIT debugger, either Dr. Watson or WinDbg
and hope the stack trace will give you the component. You also might
try enumerating the ADODB.Connection Errors collection, for additional
information.

Query Analyzer works because it isn't using the same COM stack.
However, the fact it is also reporting problems, suggest the basic
cause is with the database/data itself, or perhaps you have multiple
problems.

hth
-ralph
0
ralph
9/9/2010 6:29:31 PM
"Nobody" <trinity@nobody.com> wrote in message 
news:i6b4sm$8nv$1@news.eternal-september.org...
> Have a VB6 app that is being used to pull data from a database. Various 
> locations have this database and it has been running
> fine on all of them except for one where we are getting  the following 
> error message:
>
> "the data provider or other service returned an E_FAIL status"

Hello clone! :-)

Besides what Ralph suggested, there could be a problem with MDAC 
installation. See this article:

Component Checker: Diagnose problems and reconfigure MDAC installations
http://support.microsoft.com/kb/307255

You didn't mention what OS that this problem appears on. Vista and after 
already contain the latest ADO and Jet service packs(SP8). ADO version is 
actually 6.0+ in these OS's, so you should not have problems with these 
OS's.


0
Nobody
9/9/2010 6:49:53 PM
"Nobody" <nobody@nobody.com> wrote in message 
news:i6ba8f$u1n$1@speranza.aioe.org...
>
> Hello clone! :-)
>
> Besides what Ralph suggested, there could be a problem with MDAC 
> installation. See this article:
>
> Component Checker: Diagnose problems and reconfigure MDAC 
> installations
> http://support.microsoft.com/kb/307255
>
> You didn't mention what OS that this problem appears on. Vista and 
> after already contain the latest ADO and Jet service packs(SP8). ADO 
> version is actually 6.0+ in these OS's, so you should not have 
> problems with these OS's.

Windows XP, SP2, various patches applied. MDAC is up to date on the 
clients,
probably not on the server. The server with the issue is running 
Windows 2000, MS
SQL 7. Then again I have another server, Win 2000 and SQL 7, same 
database
structure and it is works fine

I'll try and check some of the ADO for errors. 


0
Nobody
9/9/2010 7:15:58 PM
What I see in an error for the recordset  (under activeconnections) 
object is this:

"Either BOF or EOF is True, or the current record has been deleted. 
Requested operation requires a current record."

My ADO Connection object doesn't show any errors

Wish isn't helping me much. 


0
Nobody
9/9/2010 7:23:32 PM
Why don't you idiots use real names?  Or at least *pretend* to as to not 
look like teenage trolls badly attempting to be "kewl".  Or does who you 
really are embarrass you so much, you cannot bear to reveal yourself?


"Nobody" <trinity@nobody.com> wrote in message 
news:i6bbpg$7jp$1@news.eternal-september.org...
:
: "Nobody" <nobody@nobody.com> wrote in message
: news:i6ba8f$u1n$1@speranza.aioe.org...
: >
: > Hello clone! :-)
: >
: > Besides what Ralph suggested, there could be a problem with MDAC
: > installation. See this article:
: >
: > Component Checker: Diagnose problems and reconfigure MDAC
: > installations
: > http://support.microsoft.com/kb/307255
: >
: > You didn't mention what OS that this problem appears on. Vista and
: > after already contain the latest ADO and Jet service packs(SP8). ADO
: > version is actually 6.0+ in these OS's, so you should not have
: > problems with these OS's.
:
: Windows XP, SP2, various patches applied. MDAC is up to date on the
: clients,
: probably not on the server. The server with the issue is running
: Windows 2000, MS
: SQL 7. Then again I have another server, Win 2000 and SQL 7, same
: database
: structure and it is works fine
:
: I'll try and check some of the ADO for errors.
:
: 

0
Kevin
9/9/2010 7:39:57 PM
On Thu, 9 Sep 2010 15:23:32 -0400, "Nobody" <trinity@nobody.com>
wrote:

>What I see in an error for the recordset  (under activeconnections) 
>object is this:
>
>"Either BOF or EOF is True, or the current record has been deleted. 
>Requested operation requires a current record."
>
>My ADO Connection object doesn't show any errors
>

Ha, wish you had said this before. I thought you were getting a
spurious E_Fail Error, ie, "out of the blue" per sec.

That error is usually quite specific and accurate. Somewhere in your
navigation or chewing (query, find, search, sort, move) on the
Recordset you have managed to confuse it and it is coming up with 'no
record'. 

As to why it works on other machines and not this one? My best guess
is because the data is either bad or different enough it is causing a
alternate conditional path/s.

-ralph
0
ralph
9/9/2010 8:47:23 PM
"Kevin Provance" <k@p.c> wrote in message 
news:i6bd6b$ddv$1@news.eternal-september.org...
> Why don't you idiots use real names?  Or at least *pretend* to as to 
> not
> look like teenage trolls badly attempting to be "kewl".  Or does who 
> you
> really are embarrass you so much, you cannot bear to reveal 
> yourself?
>

I mainly do it to tick people off. Much as the same reason I use a 
fake e-mail address. Does that other you to or do you have something 
that could be actually meaningful to add to the conversation?


0
Nobody
9/10/2010 4:29:57 PM
"ralph" <nt_consulting64@yahoo.net> wrote in message 
news:7ahi865j0uefuihrc1anh826m4adtm53tq@4ax.com...
> Ha, wish you had said this before. I thought you were getting a
> spurious E_Fail Error, ie, "out of the blue" per sec.
>
> That error is usually quite specific and accurate. Somewhere in your
> navigation or chewing (query, find, search, sort, move) on the
> Recordset you have managed to confuse it and it is coming up with 
> 'no
> record'.
>
> As to why it works on other machines and not this one? My best guess
> is because the data is either bad or different enough it is causing 
> a
> alternate conditional path/s.
>

Has me stumped too. We have three of the exactly same database layouts 
(internal data is a little different, but
all verified as legit data). Databases 1 and 2 the query within VB6 
works as expected, just against this third database where it is 
kicking out. I've seen various references to a possibility of it 
having to do with date fields, which there are two in the recordset, 
but I verified the data in those fields are actually dates. I even 
modified the query to make sure it only returns one record (using the 
primary key). Again, works great in query analyzer against this 
database, nothing in VB6.

We are going to re-boot the server/database on Monday and then see 
what happens.


0
Nobody
9/10/2010 4:38:18 PM
On 9/9/2010 12:39 PM, Kevin Provance wrote:
> Why don't you idiots use real names?  Or at least *pretend* to as to not
> look like teenage trolls badly attempting to be "kewl".  Or does who you
> really are embarrass you so much, you cannot bear to reveal yourself?
<snip>

Identity theft for one. And what's to prevent someone from using a name 
that is not their own?
0
Mike
9/10/2010 8:03:04 PM
On Fri, 10 Sep 2010 13:03:04 -0700, Mike S <mscir@yahoo.com> wrote:
  
>Identity theft for one. And what's to prevent someone from using a name 
>that is not their own?

Court order.  <smile>  One person I know of, as part of their
sentencing agreement,  had to sign all public postings with his real
name.  As his style was distinctive, to say the least, he was honest
for the next two years.  And still is in the newsgroups where I see
him.

Tony
-- 
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files 
  updated see http://www.autofeupdater.com/
0
Tony
9/10/2010 8:58:25 PM
"Tony Toews" <ttoews@telusplanet.net> wrote in message 
news:5t6l861pf2atiq07j6801b4shli58k2md5@4ax.com...
: Court order.  <smile>  One person I know of, as part of their
: sentencing agreement,  had to sign all public postings with his real
: name.  As his style was distinctive, to say the least, he was honest
: for the next two years.  And still is in the newsgroups where I see
: him.

You lurking in one of the news.admin.net-abuse.* groups too?  Those folks 
are vicious.  They make this group look like a catholic church on Sunday. 

0
Kevin
9/10/2010 9:12:02 PM
On Fri, 10 Sep 2010 17:12:02 -0400, "Kevin Provance" <k@p.c> wrote:
  
>: Court order.  <smile>  One person I know of, as part of their
>: sentencing agreement,  had to sign all public postings with his real
>: name.  As his style was distinctive, to say the least, he was honest
>: for the next two years.  And still is in the newsgroups where I see
>: him.
>
>You lurking in one of the news.admin.net-abuse.* groups too?  Those folks 
>are vicious.  They make this group look like a catholic church on Sunday. 

No, this is in the Microsoft Access newsgroups. 

Tony
-- 
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files 
  updated see http://www.autofeupdater.com/
0
Tony
9/10/2010 9:34:46 PM
"Nobody" <trinity@nobody.com> wrote in message 
news:i6bc7m$9cc$1@news.eternal-september.org...
> What I see in an error for the recordset  (under activeconnections) object 
> is this:
>
> "Either BOF or EOF is True, or the current record has been deleted. 
> Requested operation requires a current record."
>
> My ADO Connection object doesn't show any errors
>
> Wish isn't helping me much.

I am not 100% sure, but I think because you are using adLockBatchOptimistic, 
you get a "general" error and the details are in the Errors collection of 
the Connection object. The error means that you are trying to do something 
like MoveFirst, but the recordset is empty.


0
Nobody
9/11/2010 1:35:30 AM
Reply:

Similar Artilces:

transformation returning E_FAIL
Hi there, The following is code and explanation of steps I'm performing leading upto a transformation. However, my transformation fails and returns an E_FAIL. Please help! 1. I create an xml and xsl doc and template as follows: MSXML2::IXMLDOMDocumentPtr m_xsldoc; IXSLTemplatePtr m_pTemplate; IXSLProcessorPtr m_pProcessor; CoInitialize(NULL); m_xmldoc.CreateInstance(MSXML2::CLSID_DOMDocument40); m_xsldoc.CreateInstance(CLSID_FreeThreadedDOMDocument40); m_pTemplate.CreateInstance(CLSID_XSLTemplate40); 2. Load the xml and xsl: m_xmldoc->load(v); m_xsldoc->load(_bstr_t(xsl)); ...

What is EN on status bar?
Using Excel 2000, keyboard shortcuts no longer work. I notice an "EN" on the status bar, so I'm assuming it's related to that. Can anyone assist? Could that really be END? If it is, then that's the indicator that you hit the END key on the keyboard. It's useful when you want to go up/down/right/left until the next break in the data. I if have data in A1:A25322 with A12 selected, I can hit End|Down arrow and I go right to A25322. David McRitchie has a explanation of what the statusbar can hold: http://www.mvps.org/dmcritchie/excel/statusbar.htm gman100 wrote...

Status
This is a second posting. Initial question didn't appear in newsgroup???! When trying to convert a quote to an order, the create order form come up with status showing as -1 Clicking on status dropdown causes a client side scripting error complaining about the object being null. We have not customised anything execpt the Leads form. I have tried re- publishing all forms. Anyone got any idea what is happening? after publishing the forms trevor did you do an iisreset on the crm web server? also after doing that restart your browser and reconnect to CRM "Trevor Turner" &l...

RE: Lead status & Status Reason
Just from a previous post, I am currently unable to have my view lists populated with picklist information. Just wanted to clarify with the person who responded to me that a change in the 'UK Stack' is in fact a change of Windows Server regional settings. (Have done so from Eng-Aus to Eng-US although no apparent change other than the dates showing properly now) Am desperate to get this working now as the powers that be want a demo. Also, has anyone else had this prob? Or suggestions Am running v1.0 with CRM/SQL on same server. (Is MSDN version). ...

docmd.SetWarnings ac 97 status
How does on return what the true/false 0 or -1 of current status docmd.SetWarnings in access 97? like a dim byt_X as byte byt_X = SetWarnings(?).? without the docmd egerds wrote: >How does on return what the true/false 0 or -1 of current status >docmd.SetWarnings in access 97? > >like a >dim byt_X as byte >byt_X = SetWarnings(?).? >without the docmd Dumb, but there's no way to get that status. I suppose you could create a function or two to keep track of it, but I wouldn't bother. OTOH, you should stay away from methods that generate t...

Status shows busy on sign in and not available as desired
I can go in to options and change any item and click apply and status turns to available immediately. I can to to status and click available and otherwise it remains as busy and I never choose any option but available . ...

How ca I create an email to request status everyday automatically
I need to sent an email automatically each day to a client requesting he gave me the status of a job. Once he gave me status I want to manually delete the email and the "schedule email" that will run every day. We have in our Corporation Microsoft Exchange. ...

Delivery Status Notifications in 2003
When people request a delivery status notification when sending mail to our organization, the returned notification appears to come from my account, which happens to be the account used to install exchange, instead of something like Postmaster or System Administrator. For the life of me, I can't see where this would be configured. Can anyone suggest how this might be changed or why it is this way? Thanks, Tommy What DSNs does this happen with...NDRs , Delivery Reports or Relay DSN ? If it is an NDR, or DR, then thats abnormal, and I would request you paste a sample DSN. Howe...

Treewalker for MSXML2 in VB6
Hello! Is there anybody here who has created a treewalker class for the MSXML2 library in VB6? I have a Java project here which uses Xerces for XML handling. In this code I see that a treewalker is used to iterate through the nodes, but I am afraid that I don't really understand it yet. I cannot run the Java code, so I have to re-write this code without being able to check if I can produce the same results. If somebody already did something like that, can he please tell me? Have a nice day! Steffen Leppert On Tue, 27 Jul 2010 18:04:39 +0200, Steffen Leppert <st.l...

Stock Status Report and Historical Stock Status Report
Hello: I have been doing some experimentation, and I want to confirm this. If FIFO Perpetual or LIFO Perpetual is being used, the Unit Cost on the Stock Status Report equals the Current Cost as it appears in the Item Maintenance card. But, on the Historical Stock Status Report, the Unit Cost is the Current Cost from the purchased receipts layer according to the inventory valuation method. Are these two statements correct? And, if so, I am surprised that any report including the Stock Status Report reflects Current Cost exactly as it is from Item Maintenance. I have always understoo...

can't enable online status
Hi there, I am currently using Windows Live Messenger, and for some reason I can't turn on the online status option in Outlook Options. The option is grayed out... Does anyone has any idea of what I am missing? I am using Outlook 2007 under VISTA Ultimate. Thanks in advance! P. Do you have the most recent version of LM? -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com Outlook Tips by email: dailytips-subscribe-request@lists.outlooktips.net EMO - a weekly newsletter about Outlook and ...

Status Selection
I have set up an Access file which includes over 500 records of employees who have attended a required training class. They have two chances to pass, and the information is indicated as follows: Passed first training. (Y/N) Passed first exam. (Y/N) Eligible to attend second training. (Y/N) Passed second exam. (Y/N) However, there are those who signed up for the 1st class but had to cancel for any reason wherein this information is included in the Status field information. I finally was able to set up the query criteria for the Y/N columns, but the Status field only appears for those fou...

E_Fail Status with VB6
Have a VB6 app that is being used to pull data from a database. Various locations have this database and it has been running fine on all of them except for one where we are getting the following error message: "the data provider or other service returned an E_FAIL status" The connection string for the ADO connection looks like this: Provider=SQLOLEDB;Password=MyPassword;Persist Security Info=True;User ID=MyUser;Initial Catalog=MyDB;Data Source=MyServer The recordset is using adUseClient, adOpenForwardOnly, adLockBatchOptimistic The select statement is a simpl...

Transfers Missing from Historical Stock Status Report
When running the Historical Stock Status report I see it backs into the Quantity on Hand for the specified date by taking the current quantity and adding back transfers to other sites (Quantity Sold) and subtracting out purchase order receipts (Quantity Received). The site I am running the report for is our HQ Warehouse. It also got transfers back from other sites (branches) which show up under Quantity Received in Purchase Receipts Inquiry. These transfers should be subtracted out like a receipt but they do not show up at all on the report. At the site the items came back from the ...

Status Bar?
(Outlook XP) I have my email set to send and receive every 5 minutes, which means when I first turn on Outlook, it also checks for and downloads email then. Down in the status bar the progress is always hidden behind one of those lines and I can only see part of it. I tried dragging that line to the side but it won't work. If I manually click "Send Receive" then I can see the whole progress. This to seems like an Outlook flaw to me because it did it on my older 2000 version too. I don't recall how it works in those old versions but I do know it can't be change...

Difference between Status and Status Reason fields
Hi, Can someone please help me understand the difference between Status and Status Reason fields in CRM records, such as Accounts? They seem to always be Active or Inactive together and filtering in Advanced Find by one or the other returns the same count. I know one is supposed to be a system flag and the other for users or something like that. Any explanation is appreciated. Thank you. On Jul 2, 9:20=A0pm, msandid <msan...@gmail.com> wrote: > Hi, > > Can someone please help me understand the difference between Status > and Status Reason fields in CRM records, such as Ac...

Inventory Historical Stock Status Report
I am still running GP 6.0. When I run the Inventory Historical Stock Status Report on a single site, I have not issues. When I run this on everything, it hangs after about 46,000 records. A few times, it made it to 47,000 records. Our database size is 10.5 GB. Is there a size limitation to this report, or are there any known issues with this report in 6.0? We do not have any errors in the event logs on the SQL server, or the application server where we run GP 6.0 ...

How to generate list of items with same status over three or more successive days
I would like to ask the community to help me with the following case. We do have a vehicle tracking business and need to monitor vehicle status every day. We are looking for a way to get a list on a daily basis of vehicles that has their status not changed over three days. Columns of the feeder: Date VehicleNr Status (consider A, B, ..., F) The idea is to add the feeder on a new sheet, so comparison will be over more sheets. Columns of generated list of vehicles with same status over more then three days: VehicleNr Status List generation on the same sheet that is refreshed daily. The li...

Connector status is unavailable in status Container
Hello I have exch2003 with SP1 with four routing groups, routing group are connected through routing groups connector, routing group are connecte in hub topology style, now from two routing group mail is not going to hub routing group, if we see the queue of thses routing group server mails are under unreachable queue, but if we restart the server the mail are going to hub routing group but then again stuck in the queue. I have check phyical connectivity, nobody has modified anything on network configuration, by IP, by name and by FQDN I can ping from hub routing group and the group ...

Status.htm
Hi folks Looking for some help on displaying the total item count on the status.htm display. This would help my cashier make sure that they didn't forget to scan an item. So each time an item gets scan the count would increment. Thanks again Danny shoot me an email & I'll email the code for the display to you. jerry@jrdata.us -- -Jerry JR Data Inc. "Dan-902" wrote: > Hi folks > > Looking for some help on displaying the total item count on the status.htm > display. This would help my cashier make sure that they didn't for...

FRx
Hi, We are all of a sudden getting an error when running FRx reports on the Windows Server. The error is Data Provider or other service returned an E_FAIL status Error-245755 We can still run the reports locally. Any thoughts as to why this may be happening now. The only thing that has changed recently is that we have loaded new budgets into Great Plains and I did GL reindexing within Frx ...

CRM 3.0
Hi all, I have 1 client which is getting an error attempting to go offline. Below is the event logged in Windows Event viewer. The system in question is Vista SP2, CRM 3.0 V3C with Rollup 3, SQL 2005 express SP3, I have attempted to unselect ALL local data entries and attempted going offline and still i get the error. It appears it fails when it trys to sync 1108 appoinements to outlook, but checking the user account appoinements in CRM the user does not have this many. I have recreated the users profile, I have uninstalled SQL and CRM client but still get the same error. I am now st...

Status
I have a macro which runs a (very long) series of make table queries. The process takes up to 10 minutes and I run it by clicking on a button in a Switchboard page. Is there any way to have the name of the particular query show somewhere on the screen so I can make the user happy that something is actually happening, with the query name changing to show the appropriate query that is being run TIA Steve On Sep 4, 3:17 am, Steve <goo...@coxcomputers.annabay.net> wrote: > I have a macro which runs a (very long) series of make table queries. > The process takes up to 10 minutes and...

System Jobs for Matchcode update stuck in waiting status
System Jobs for Matchcode update stuck in waiting status. Does anyone know how to resolve this? It seems to be for Leads, Accounts, and Contacts. Also, does this affect workflows? -- Onetreeup The status waiting may indicate the workflow has run into an exception. To view this open the advanced find on the system jobs and add the columns message and error code to the view, this will give any additional information if available. This may help you to resolve the issue. -- Patrick Verbeeten (MCPD) Lead Developer Aviva IT Extended Entity and Plug-in browser: http://www.patrickverbeete...

Case status
All Can you add another status to the status's in MSCRM 3.0. Currently the status are "Active, Resolved and Cancelled" I wished to have a "Closed" Status to create a 2 stage closure process for my cases. Eg First stage of Closure - Resolved - Message to customer asking if problem is resolved Second Stage - either customer confirmby return or x amount of time passes and case will be set to "CLOSED" Can anyone help The simple answer is no You will need to work out a solution within the constraint of fixed statuses but customizable status reasons...