MySQL Bugs: #29270: On Connect to a Database the Connector throws an Error

Bug #29270	On Connect to a Database the Connector throws an Error
Submitted:	21 Jun 2007 14:26	Modified:	21 Jun 2007 14:52
Reporter:	Frank Mussmann	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	Connector / ODBC	Severity:	S2 (Serious)
Version:	3.51.16	OS:	Windows (XP Professional)
Assigned to:	Jim Winstead	CPU Architecture:	Any
Tags:	3.51.16, error, MySql Connector, SQL_AUTO_IS_NULL

Description:
When connecting to a Linux-based Mysql-Database (Version: 3.22.21) the following Error comes along, and I can't connect to the Database(s):
[MySQL][ODBC 3.51 Driver]You have an error in your SQL syntax near 'SQL_AUTO_IS_NULL=0;' at line 1
It's strange, because the same runs on other machines, but on serveral ones with the same Softwarestuff installed, it fails with this Message.

How to repeat:
Install the mysql(3.22.21) on a linux (it's a Suse Linux 6.1 Kernel: 2.2.7) (a productive machine, and i will not upgrade !!!), install Windows XP Pro with the MyODBC 3.51.16 and try to connect.

Suggested fix:
No Idea.

MySQL Connector/ODBC no longer supports version 3.22 of the server, only version 4.1 and later. If you need to keep using such an old version of the server, you'll have to use an older version of our ODBC driver. I'm not sure what version that would be, given how long-obsolete 3.22 is. You might check to see what version of the ODBC driver was bundled with your version of SuSE.

You can download old versions of the driver at http://downloads.mysql.com/archives.php

the latest working version I know of is 3.51.12
But it is working with recent 3.51 if one sets 
….PORT=3306;OPTION=8388608;DATABASE=…..
in the connector string if connecting from within a program.

Unfortunately I don't know how to do this in the odbc driver options or how to use my.cnf ....