2

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

2 Answers 2

2

Perhaps this bug report will help you find a resolution

1
  • You were correct...the answer was in bug report. Thanks so much. I will answer it myself for any other people that are reading this question and want a quick answer but I will give you the credit.
    – bvandrunen
    Feb 23, 2010 at 23:29
1

The answer pertains to the 32-bit limit on queries for ODBC connector. Here is a link to the bug report:

http://bugs.mysql.com/bug.php?id=31413

and the quick answer:

Solution:

1 - On Windows XP just go to Administrative Tools -> Data Source(ODBC) -> Select your ODBC connection which you have used for Linked Server.

2- Click on "Details" button

3- Click on "Flag 3" Tab

4- Checked the option "Limit Column Size to 32-bit range"

This will limit longtext field to 32-bit range so that your query will work.

that's it. Your query will work now without modifying the schema, as i was not in favor of modifying existing schema.

Note: Please make sure that you are not loosing data, in my case the actual data was in range of 32-bit . So it worked for me.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .