Multiple Recordsets

Multiple Recordsets

Postby 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?
Posts: 1
Joined: Tue 24 Mar 2009 17:55

Postby 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.
Devart Team
Posts: 7880
Joined: Thu 14 Aug 2008 12:44

Return to dotConnect for MySQL