MySQL Bugs: #646: MyODBC 3.51.06

Bug #646	MyODBC 3.51.06
Submitted:	12 Jun 2003 17:12	Modified:	8 Jul 2003 0:45
Reporter:	Ahm Asaduzzaman	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S3 (Non-critical)
Version:	3.51.06	OS:	Windows (Windows XP)
Assigned to:	Bugs System	CPU Architecture:	Any

Description:
Bug Report:
I am finding an error with MyODBC 3.51.06 while importing data with following command/query. Howevr, It works fine with MyODBC 2.50.XX

LOAD DATA LOCAL INFILE...

Thank You.

How to repeat:
Import data from a text file (fields are delimited) to a table using above command. (Platform Windows, MySQL version: 3.23.55 and above)

Suggested fix:
No Idea

Hi !! 
 
Can you be more specific on the problem ? Does it cause problems while executing LOAD 
DATA INFILE command or does it cause when retriving the results .. ?? 
 
Becuase I was wondering from driver end, as it only passes the query to server and acts a 
dummy layer for these commands. 
 
Anyway, I wil be testing this now, and let you know the status. 
 
Thanks, 
Venu

Following is the scenario that provoked us to make a conclusion that MySQL ODBC 3.51 driver has a bug:

Bug Ref: http://bugs.mysql.com/?id=646&edit=2

What we are doing: 

=====================

We have developed a project, all user interface we devoloped using Microsoft Visual Basic 6.0 and we use MySQL database to store data.

How we are using ODBC: 

=====================

So far we have been using MySQL ODBC driver 2.50.37.00 and had no problem.

Recently we decided to use MySQL ODBC 3.51 driver, because its easy to install for our customers.

This is the connection string we used for ODBC 2.50:

"Driver={MySQL}; Server....blah blah

This is the connection string we used for ODBC 3.51:

"Driver={MySQL ODBC 3.51 Driver}; Server....blah blah

Operating System: Windows 98, Windows 2000, Windows XP

MySQL version we used: 3.23.52, 3.23.55, 3.23.56, and 4.0.1

 

The Problem:

===============

Everythings so far works fine with ODBC 3.51, even the export query works as expected.

But it doesn't work with Import query.

Attached  the example of import query and the error message after issuing the query. (ATTACHED FORWARDED TO VENU@MYSQL.COM)

 

 

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------

Must set --local-infile=1 under [client] or [odbc] sections of the my.ini or my.cnf configuration files. 

Note to check 'Read Options From my.cnf' OPTION from DSN configuration, in case if the option is set under [odbc] section of the configuration file.

Thanks
Venu