Multiple Recordsets

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
eentenman
Posts: 1
Joined: Tue 24 Mar 2009 17:55

Multiple Recordsets

Post by eentenman » Tue 24 Mar 2009 17:58

I am upgrading a site from .NET 1.1 to 2.0 and i have been using CoreLab.MyConnect for years. I upgraded the reference to the express dotConnect library and its now throwing a syntax error when i try and execute a command with multiple record sets.

The same code query worked fine with the older CoreLab product. I check the docs and i have my queries separated by a ;.....The only other thing i can think of is that i am connecting to an older 4.0xx mysql db.

Any suggestions?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Wed 25 Mar 2009 12:24

Multiple record sets are supported by MySQL server starting from the 4.1 version. If you use an older version of MySQL server you can execute multiple queries with the MySqlScript component.

Post Reply