Handling BLOB's between SQL Server 2K and mySQL DB !!? -
02-07-2005
, 04:15 AM
Hi there
for some reason I've to modify data in an existing customer database mySql V
4.0.23 . Some data is there stored in BLOB's and I can export the data via
DTS into my SQL Server 2K, modify the data and then try to store the data
back into mySQL. But unfortunally I'm not able to write the BLOB's back to
the mySql DB, the other data goes fine.
I get the following error message :
Error Source: Microsoft OLE DB Provider for ODBC Drivers
Error Description:Query-based insertion or updating of BLOB values is not
supported.
The connection to the mySQL DB is done via an ODBC driver mySQL 3.51
Any hint how to solve this problem ??
Thanks
Chris |