Hi guys

I get a strange error when I try to connect to an Oracle data source using their OLEDB Provider. I seem to be intermittent but I get
the error number 265946: Multiple-step operation completed with one or more errors. Check each status value.

Has anyone received this error before?
What does it mean?

This is quite urgent and it only started happening recently and I'm due to deliver to a client tomorrow!

Thanks

Ciaran

Ciaran,

I get this sometimes connecting to Sybase DBs. I think it just means that the OLEDB isn't able to give you detailed information about the error e.g. when something fails inside a stored procedure that you're calling over the link. Do you have a way of interactively executing the command (in SQL server I'd use Query analyser)? This will probably tell you what the precise error is.

HTH

Chris

There are two secrets to success in this world:
1. Never tell everything you know

Hi Chris

Thanks for replying.
Since this seems to be an entirely intermittent error, it is difficult to reproduce. I do have the Microsoft SDK which allows me to test OLEDB commands but I don't think if it allows me to test connections.

Ciaran
Are you saying that just making the connection causes this error, i.e. before you even try to execute any commands?
I think you might also find this useful http://www.embarcadero.com/downloads...adrapidsql.jsp (only a 7-day demo, sadly :(). We use this as our client-side for non-MS SQL development. You should be able to connect to your Oracle db, and execute whatever it is you were trying to do over the OLEDB link. Hopefully this will give a hint into what the problem is.

Chris



There are two secrets to success in this world:
1. Never tell everything you know

Hi Chris

Yes, it is the connection I have an intermittent problem with here.
I'm using an OLE Provider from Oracle.

Hmm, let me make some assumptions here:

You have an app that opens a connection to the db.
This connection does not in itself do anything.
This connection occasionally fails when trying You are not using the form to do something on this connection.
You are using all the latest versions of MDAC and the oracle OLEDB Provider.
You are not trying something new on the connection e.g. testing a new dataset, executing a brand-new query or connecting to a different server etc.

Try swapping the oracle provider for the Microsoft version "MSDAORA"



There are two secrets to success in this world:
1. Never tell everything you know

Hi Chris

Here is my connection string using OLEDB

initConn.ConnectionString = "Provider=OraOLEDB.Oracle;Data Source=dw92;User ID=/;PLSQLRSet=1;"

What is the syntax for MSADORA in my case?

Cheers for your help

Ciaran

initConn.ConnectionString = "Provider=MSDAORA;Data Source=dw92;User ID=/;Password=;"

If this doesn't work, post the rest of your connection/execution code when you reply.

Hi Chris

I found a bug on the Oracle site, don't worry about this.

Cheers

Ciaran

What did you find? I'm getting this error with ASP and Oracle. I can connect ok, but get errors on execute of SQL.