------_=_NextPart_001_01C50878.F18AD3B9
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

We are trying to do multiple selects in dotnet but seem to be getting an
error. This was working just fine with the MySQL dotnet driver, so the
query is fine. But we seem to be getting an error when multiple
statements are used of any sort. This can be inserts or selects. So is
this a limitation of the mysql odbc driver or the odbc driver in dotnet
or am I the only one that seems to be having troubles?



Lance Johnson
DOCS, Inc.
Lead Programmer
www.SOAPware.com
(800)455-7627




------_=_NextPart_001_01C50878.F18AD3B9--

I think it may be in the ODBC standard that only one SQL statement at a
time is allowed.

The .NET connector may be more liberal.

John Bonnett

-----Original Message-----
From: Lance Johnson [mailto:ljohnson [at] DOCS.com]
Sent: Wednesday, 2 February 2005 2:40 AM
To: myodbc [at] lists.mysql.com
Subject: multiple selects

We are trying to do multiple selects in dotnet but seem to be getting an
error. This was working just fine with the MySQL dotnet driver, so the
query is fine. But we seem to be getting an error when multiple
statements are used of any sort. This can be inserts or selects. So is
this a limitation of the mysql odbc driver or the odbc driver in dotnet
or am I the only one that seems to be having troubles?



Lance Johnson
DOCS, Inc.
Lead Programmer
www.SOAPware.com
(800)455-7627




--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc [at] m.gmane.o rg