MyODBC Problem with SQL2000 -> MySQL Data Transformation

["Jack A. Fobel" <jfobel@xxxxxxxxxxxxxxxx>]

Hi Folks,

I'm having a problem when I try to populate a MySQL database using DTS in
SQL2000. The data types on the SQL2k table are varchar, as well as the types
in MySQL. I am receiving a 'Data Overflow' error for each column that it
tries to update. I've tried numerous ways of population, each failing with
this error code. I'm beginning to think it is the MyODBC driver.

I connect to SQL2k with OLD DB and use MyODBC to connect to MySQL.

Have any of you tried doing this yet? Just curious that maybe you have run
into this before.

Thanks,


Jack
jfobel@xxxxxxx


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread92849@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php