Devart Forums

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?

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.