Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old April 13th, 2004, 04:35 AM
Authorized User
 
Join Date: Mar 2004
Location: , , .
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
Default Error 265946 when using OLEDB with Oracle from VBA

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
Reply With Quote
  #2 (permalink)  
Old April 13th, 2004, 05:05 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: London, , United Kingdom.
Posts: 132
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #3 (permalink)  
Old April 13th, 2004, 08:03 AM
Authorized User
 
Join Date: Mar 2004
Location: , , .
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.
Reply With Quote
  #4 (permalink)  
Old April 13th, 2004, 08:56 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: London, , United Kingdom.
Posts: 132
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #5 (permalink)  
Old April 13th, 2004, 09:20 AM
Authorized User
 
Join Date: Mar 2004
Location: , , .
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Chris

Yes, it is the connection I have an intermittent problem with here.
I'm using an OLE Provider from Oracle.
Reply With Quote
  #6 (permalink)  
Old April 13th, 2004, 10:00 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: London, , United Kingdom.
Posts: 132
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Code:
ADOConnection.Open
You are not using the
Code:
ADOConnection.Execute
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
Reply With Quote
  #7 (permalink)  
Old April 13th, 2004, 10:31 AM
Authorized User
 
Join Date: Mar 2004
Location: , , .
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #8 (permalink)  
Old April 13th, 2004, 10:39 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: London, , United Kingdom.
Posts: 132
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.
Reply With Quote
  #9 (permalink)  
Old April 13th, 2004, 11:15 AM
Authorized User
 
Join Date: Mar 2004
Location: , , .
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Chris

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

Cheers

Ciaran
Reply With Quote
  #10 (permalink)  
Old July 29th, 2004, 05:00 PM
Registered User
 
Join Date: Jul 2004
Location: New Orleans, La, USA.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error OLEDB conexión REGDB_E_CLASSNOTREG sabinaNET ASP.NET Espanol 0 December 21st, 2004 06:20 PM
MSJet.OLEDB.4.0 reported an error in ASP.NET mdrafi ADO.NET 0 September 12th, 2004 11:09 PM
MSJet.OLEDB.4.0 reported an error in ASP.NET mdrafi Visual Studio 2005 0 September 12th, 2004 11:07 PM
OleDb.Net vs. ODBC.Net for Connecting to Oracle cjo ASP.NET 1.0 and 1.1 Professional 3 January 13th, 2004 07:18 PM
OleDb.Net vs. ODBC.Net for Connecting to Oracle cjo ASP.NET 1.0 and 1.1 Basics 1 December 23rd, 2003 10:56 AM



All times are GMT -4. The time now is 09:57 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.