May 29, 2007 at 11:13 am
Recently, we've been experiencing a very frustrating situation whereby a linked server from SQL 2005 to either MySQL or to Sybase will fail, intermittently, generating an "unexpected catastrophic failure" error.
The end result is a hung process that cannot be killed, ultimately forcing a reboot of sql server.
A case has been (re)opened at Microsoft regarding this serious problem:
https://connect.microsoft.com/SQLServer/feedback/Validation.aspx?FeedbackID=187192
One person posted a possible solution on sqlservercentral.com for mysql, but that solution has yet to prove itself.
Does anybody have a solution to this issue?
Thanks in advance,
Peter Z
May 29, 2007 at 1:27 pm
Google is your friend...
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=53092&SiteID=1
A.J.
DBA with an attitude
May 30, 2007 at 7:49 am
A.J.:
Thanks for your willingness to help. Unfortunately, our linked server to Sybase is configured as described in the microsoft forum link you provided; works most of the time, but not all the time. So, something else is at fault here. Plus, it doesn't solve the issue of an unreliable linked server to MySQL.
Any other suggestions welcome!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply