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_S
lonzo" <[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
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]>
>
