I have created linked connection in SQL and by which I am connecting Oracle server using OLE DB provider "OraOLEDB.Oracle".

SQL Server = 2008 R2 Oracle = 10g

Normally, When I am executing Insert or Select query it works fine, but some times the same query does not execute well and failure. Same query If I execute again then it works fine.

The Error message is as below.

The OLE DB provider "OraOLEDB.Oracle" for linked server "ABC" could not INSERT INTO table "[ABC]..[M_SCM].[MY_TBL]". err src line: 23 SP_MY_PROCEDURE

Can any one suggest the cause of the issue? and let me know if any solution.

  • are you using RAC on the Oracle side? have you setup the connection string correctly? – Nick Kavadias Nov 28 '13 at 14:05
  • @Nick, I am using Linked Connection not using RAC. and connection sting is correctly written. It is executing as per expectation daily but once in a month it fails thats why I want to fix this issue as my process is in automation. – Nitin Vijay Dec 27 '13 at 5:53
  • in that case my best guess is that there's a firewall somewhere between the hosts closing the connection after a timeout. – Nick Kavadias Jan 3 '14 at 0:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.