OpenEuphoria

Re: Matt's ODBC wrapper and Mysql

• Posted by Matt Lewis <matthewwalkerlewis at yahoo.com> Nov 03, 2004
• 651 views

George Walters wrote:
> 
> 
> Matt, It seems that all syntax errors in an SQL statement are now being
> reported as invalid handle. I beleive this began when I upgraded MySql
> to their current version 4.015. At least this has been the case of the 
> last 3 or 4 bugs of mine. On the older MySql it always seemed to report the
> position on the line and showed the text following that position. Have you
> found anything that might remedy this?

I don't know.  I have v4.0.21, and here's the error message I got
from a bad query:

ODBC Error 0: [4] [MySQL][ODBC 3.51 Driver][mysqld-4.0.21-nt]Unknown column 'x'
in 'field list'

> I've also noticed from an executing program when I close the DB that my dos
> screen which is running MySql line interpreter usually loses it's connection
> to
> the data base.. any thoughts on this one? A command of "use DBname"
> reconnects.

Were you able to run queries without the 'use' command previously?  
Because I believe you either need to do the 'use db' command or add the
db name to table and field names.

Matt Lewis