Hello everyone.
I am attempting to export data from VFP tables to MySQL (a linux RDBMS). I am running into a snag with data contained in memo fields. MySQL doesn't use memo fields (it has its own way of dealing with memo-style text). There is an ODBC driver for MySQL. When I used that, I could just send the data over to MySQL and it accepted handled the memo fields fine. The only problem being when there were "'"'s in the data. To avoid those problems I started using ADO. But now I always get an OLE Dispatch error when I try to send the memo field over (incorrect data handler) no matter what type I use in MySQL (VARCHAR, MEDIUMTEXT, etc). It's almost as if ADO doesn't know how to handle the memo fields.
A little help would be greatly appreciated.
Thanks.
j