Home » Other » General » Pblm with OraOLEDB.Oracle provider - Multiple-step operation generated errors. Check each status val
Pblm with OraOLEDB.Oracle provider - Multiple-step operation generated errors. Check each status val [message #134787] Sat, 27 August 2005 00:47 Go to next message
stayi
Messages: 8
Registered: August 2005
Junior Member
Hi,

I have been using MSDAORA.1 provider till recently when I changed to OraOLEDB.Oracle provider.

After changing to this I started getting a error.

My test VB code:

Dim cn As New ADODB.Connection
Dim rsDtl As New ADODB.Recordset
Dim sSQL As String

sSQL = "SELECT A.DSP_SKU FROM A,B WHERE A.1 = 'YREPLSKU01' A.2=B.2"

cn.ConnectionString = "Provider=OraOLEDB.Oracle;Password=XXX;User ID=XXX;Data Source=XXX"
cn.Open
rsDtl.CursorLocation = adUseClient
rsDtl.LockType = adLockOptimistic
rsDtl.Open sSQL, cn

rsDtl.Fields("DSP_SKU") = "1" 'It fails here if we use OraOLEDB.Oracle provider instead of MSDAORA.1.

NOTE: IT works fine if my recordset is a result of a single table query as below.
sSQL = "SELECT DSP_SKU FROM A WHERE 1 = 'YREPLSKU01'"

Please comment if there is a known solution for this.

Thanks.

[Updated on: Sat, 27 August 2005 02:08]

Report message to a moderator

Re: Pblm with OraOLEDB.Oracle provider - Multiple-step operation generated errors. Check each status [message #134798 is a reply to message #134787] Sat, 27 August 2005 03:53 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
stayi wrote on Sat, 27 August 2005 07:47

After changing to this I started getting a error.


You forgot to mention what errors you are getting.

MHE
Re: Pblm with OraOLEDB.Oracle provider - Multiple-step operation generated errors. Check each status [message #134800 is a reply to message #134798] Sat, 27 August 2005 03:57 Go to previous messageGo to next message
stayi
Messages: 8
Registered: August 2005
Junior Member
I get this error:

Multiple-step operation generated errors. Check each status value.
Re: Pblm with OraOLEDB.Oracle provider - Multiple-step operation generated errors. Check each status [message #134804 is a reply to message #134800] Sat, 27 August 2005 04:11 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
A google for the error told me this:
 This error means that one or more fields you are inserting/updating contain an invalid value. Some of the possible scenarios are:

1. A string value is being inserted into a numeric field.
2. An invalid date expression is being inserted into a date field.
3. A string value being inserted is longer than the size of the string field.
4. A null value is being inserted into a field that does not allow nulls. 
Verify the data types.

MHE
Re: Pblm with OraOLEDB.Oracle provider - Multiple-step operation generated errors. Check each status [message #134805 is a reply to message #134804] Sat, 27 August 2005 04:12 Go to previous messageGo to next message
stayi
Messages: 8
Registered: August 2005
Junior Member
But thats not the case. The datatype is fine. Note that I stated it works fine if the recordset is from a single table, its only when we have joins that it starts throwing this error.
Re: Pblm with OraOLEDB.Oracle provider - Multiple-step operation generated errors. Check each status [message #134811 is a reply to message #134805] Sat, 27 August 2005 04:35 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Sorry, I'm no Visual Basic specialist. I can only point you to MSDN: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q269495

Do the queries work in SQL*Plus? Have you tried a simple EMP/DEPT join from the SCOTT schema?

MHE

[Updated on: Sat, 27 August 2005 04:39]

Report message to a moderator

Re: Pblm with OraOLEDB.Oracle provider - Multiple-step operation generated errors. Check each status [message #134812 is a reply to message #134811] Sat, 27 August 2005 04:38 Go to previous messageGo to next message
stayi
Messages: 8
Registered: August 2005
Junior Member
Thank you. Not an issue!

icon9.gif  Re: Pblm with OraOLEDB.Oracle provider - Multiple-step operation generated errors. Check each status [message #196264 is a reply to message #134812] Wed, 04 October 2006 12:27 Go to previous message
heoracle
Messages: 1
Registered: October 2006
Junior Member
Did you ever find a solution to this problem?

I am having the same issue.
Previous Topic: Question
Next Topic: Failure to enlist in resource Manager
Goto Forum:
  


Current Time: Tue Dec 06 00:05:24 CST 2016

Total time taken to generate the page: 0.05711 seconds