Problem using MySQLDriverCS

[Rob Nicholson]

I'm doing some experimentation with MySQL to see if we can support it with
our next version of our application under VB.NET. I'm trying to use the .NET
MySQLDriverCS set of libraries but I seem to be struggling with some of the
syntax.

I'm trying fill a dataset using the following SQL command:

Drop Table If Exists `Temp0`;
Create Temporary Table `Temp0`
Select * From `KnowledgeCentres`;
Select * From `Temp0`;

This works fine when I execute the SQL in MySQL Control Centre but
MySQLDriverCS throws up an error about the syntax being wrong near ";"

Is it legal to pass multiple SQL commands in a MySQLDataAdapter.Fill
operation? Is this ";" format just supported by the tools as isn't legal
MySQL?

A simple fudge to do "Select * From `KnowledgeCentres`" works fine so the
rest of the code is okay.

Thanks, Rob.