June 1, 2012 at 9:35 am
We see this error from time to time via the application. It connects to a SQL2008R2 SP1 CU4 and has a linked server back to SQL2000 SP4 database. The issue is the queries running through the linked server. Has anyone ever seen this issue? I haven't been able to find much on it.
Caused by: java.sql.SQLException: [BEA][SQLServer JDBC Driver][SQLServer]The OLE DB provider "MSDASQL" for linked server "DBSQL99" reported an error. The provider reported an unexpected catastrophic failure.
June 1, 2012 at 11:40 am
Check out this link: http://blogs.msdn.com/b/john_daskalakis/archive/2009/11/13/9921916.aspx
I've had this happened before (not with the JDBC drivers) and the cause could relate to your issue as well.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 1, 2012 at 11:50 am
Thanks for the reply.
It happens once in a while, they try it again and it works. Causes the stack dump in SQL Server but does not effect SQL Server negatively. I have opened a case with MSOFT on the issue.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply