Mysql – SQL Server: severe error when querying a MySQL Linked Server

linked-serverMySQLsql serversql-server-2005

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

Best Answer

Perhaps this bug report will help you find a resolution

Related Topic