The official mySQL response is that you are overflowing the maxlength
attribute
Although there are many posts where SQLServer to MySQL have caused this
error
the solutions I have seen say go plain text and import using LOAD DATA
INFILE
Martin
----- Original Message -----
From: "David Alonzo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 13, 2003 4:30 PM
Subject: SQL Server 2000 to mySQL Server
> I'm trying to do an export from an SQL Server 2000 Database to and ODBC
driver pointed to a mySQL Server Database. The export works if there is at
least one record in the mySQL table. If the mySQL table is empty it gives
an error that looks like this:
>
> Insert error, column 1 ('field1', DBTYPE_STR), status 6: Data overflow.
>
> The strange part is that the export works perfectly fine as long as there
is one record in the mySQL table, if there are no records in the table, I
get the error above.
>
> Thank you for your help.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
