This is a mySQL problem methinks and it would appear to be self-explanatory.
-----Original Message----- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: 27 March 2003 14:29 To: CF-Talk Subject: OT-DTS Anyone ever used DTS to migrate data from MS Access to MySQL? I've installed the MyODBC driver and created an ODBC connection then I'm using DTS to export the data from the specified access db to the mysql db. It creates all tables, but when inserting Memo type columns (I think) it gives this error: "Query-based insertion or updating of BLOB values is not supported." Do I need to customize the query and convert the data to another datatype? I'm new to MySQL. Thanks, Greg ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4