[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-odbc
Subject:    RE: load data bug ?
From:       "Mathieu DESPRIEE" <mathieu.despriee () transatel ! com>
Date:       2003-07-24 13:27:48
[Download RAW message or body]


Thanks for your suggestion, but that does not work, and it's not
surprising : the SAME request WORKS with odbc 2.50 and DOES NOT work
odbc 3.51. The problem is somewhere else.
Does myodbc 3.51 handle local files differently than 2.50 ?
 
Mathieu
 

-----Original Message-----
From: Rahmat Hidayat [mailto:tomat09@yahoo.com] 
Sent: jeudi 24 juillet 2003 15:07
To: Mathieu DESPRIEE
Subject: Re: load data bug ?



I think that because 'E:\\DevL\\file.csv' cannot be found.. perhaps you
need to change those into 'E:/DevL/file.csv'

In : MySQL 3.23.49 and MySQL 4.0.2 LOCAL  will only work if you have not
started mysqld with --local-infile=0 or if you have not enabled your
client to support LOCAL. Using LOCAL  will be a little bit slower than
letting server access the files directly

http://mahasiswa.if.itb.ac.id/~if11016

yahooid tomat09

yahooid tomatotti_1982

Peace Love and Freedom


Mathieu DESPRIEE <mathieu.despriee@transatel.com> wrote:


Hi everybody

(I apologize if this problem has already been submitted on this list,
but I didn't find...)

I have a .NET application talking to a mysql DB through : 
.NET ODBC Provider -> MyODBC 2.50 -> Mysql 

The application runs this request :

LOAD DATA LOCAL INFILE 'E:\\Devl\\file.csv' INTO TABLE CDR FIELDS
TERMINATED BY ';' LINES TERMINATED BY '\r\n'
(Id,Msisdn,InvoiceNumber,RecordDate,OperatorId,OperatorCallType,Transate
lCalltype,StartDate,StartTime,Duration,CallingNumber, 
DialedNumber,Status,StatusDate,Charge,DestinationOrigin)

and this works very well.

Now, if I upgrade MyODBC to 3.51, the same request returns the error :
"Can't get stat of file blah blah"

Any idea ? Is it a know issue in MyODBC ?
Thanks



Mathieu DESPRIEE
IT Engineer
Transatel 
www.transatel.com



-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=tomat09@yahoo.com




  _____  

Do you Yahoo!?
SBC
<http://pa.yahoo.com/*http://rd.yahoo.com/evt=1207/*http://promo.yahoo.c
om/sbc/> Yahoo! DSL - Now only $29.95 per month!



[prev in list] [next in list] [prev in thread] [next in thread]