Working on v8.1 I'm importing a MYSQL table with an index key and unlimited text type column. When importing this into FM the memo field is coming in as data type txtblob and when tring to test I am getting the following error.
"This query contains an error and can not be executed.
It is recommended that you view the query feedback on the "Query Information" tab.
RQP-DEF-0177 An error occurred while performing operation 'sqlROpen' status='-9'.
UDA-SQL-0107 A general exception has occurred during the operation "prepare".
[MySQL][ODBC 3.51 Driver][mysqld-5.0.18-nt-log]SQLBindParameter not used for all parameters"
Is there anything in FM I do to resolve this as I have tried every advanced option going in the ODBC connection, and there is no further info on the Query Information tab- Help please?????
I THINK I remember, although it's been a while, reading about improved mysql integration in 8.4. I see you're using 8.1, so that may be a problem.
In any case, have you tried changing the datatype of the blob to a varchar? If CAST (dataitem,varchar(n)) doesn't work, try using CONVERT(varchar(n),dataitem) as column_name
this might help:
https://www-304.ibm.com/support/docview.wss?uid=swg21344133
(https://www-304.ibm.com/support/docview.wss?uid=swg21344133)