Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Bounty Bob
Starting Member
12 Posts |
 Posted - 2004-10-22 : 09:13:48
|
| Hi guys,I've got a problem with a SQL Server stored procedure that links to an Oracle database. The stored procedure executes a command in Oracle using OpenQuery and the results of this query are returned to a temporary table in SQL Server.My VB application executes this stored procedure anywhere between 50 and 300 times (depending on how many records I need to import from Oracle).The problem is that every now again, the stored procedure fails with the following message: -OLE DB error trace [OLE/DB Provider 'MSDAORA' ITransactionJoin::JoinTransaction returned 0x80004005: The provider did not give any information about the error.].This will happen for the next 10-20 records before righting itself. If I later reimport the records that failed, they import fine.I'm obviously getting this "non" error message because the error occurs on Oracle and not SQL Server. However, does anyone know how I can find out what the actual error that's occuring is?Cheers,Rob |
|
|
|
|
|
OLE DB Error