MySQL Forums
Forum List  »  Microsoft SQL Server

Data overflow error with MySQLODBC
Posted by: chris
Date: February 09, 2005 03:46PM

I have been testing the MySQLODBC driver with plans to migrate our databases from MS SQL Server 2000 to MySQL. When I use DTS to export from MS SQL to MySQL, I receive an Insert error "status 6, Data overflow" for any of the varchar datatypes. int and bigint datatypes transfer just fine. Ironically, when I use the NAVICAT for windows Import Wizard to try it in the other direction, I can import all the varchar data BUT NOT the int datatypes.

Any help anyone can provide would be most appreciated.

MySQL version 4.1.9-standard.
MyODBC the latest version

Options: ReplyQuote

Written By
Data overflow error with MySQLODBC
February 09, 2005 03:46PM
February 22, 2005 02:21PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.