RE: MyODBC Problem with SQL2000 -> MySQL Data Transformation

[Venu <venu@xxxxxxxxx>]

Hi, 

> -----Original Message-----
> From: Jack A. Fobel [mailto:jfobel@xxxxxxxxxxxxxxxx]
> 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 <venu@xxxxxxxxx>
 / /|_/ / // /\ \/ /_/ / /__  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 <mysql-thread92866@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php