Hey, I have been having a problem with my linked servers. I am using Microsoft Server 2003 and Microsoft SQL Server Management Studio 2005.
The linked server is a MySQL database. It was defined through SSMS along with all our other databases being controlled through SSMS.
The problem is that for any query that last for more than 5 sec I get this error:
**[Msg 0, Level 11, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded.
Msg 0, Level 20, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded.]**
Any other query under 5 sec works fine. I am doing simple
select * from tables. I have checked all the time-outs etc and have them set at unlimited. Any help would be greatly appreciated. Thanks