Hi, > -----Original Message----- > From: Jack A. Fobel [mailto:[EMAIL PROTECTED]] > Sent: Saturday, December 01, 2001 3:22 PM > To: MySQL List > Subject: MyODBC Problem with SQL2000 -> MySQL Data Transformation > > > 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. >
Last week only I spent some time on this issue, as the DTS from MS is not mapping the varchar columns properly to MySQL when using MyODBC, and in some cases it maps varchar to set :) I will trace down the problem this week, and I will update you on that. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ www.mysql.com --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
