If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Issue viewing txtblob in FM

Started by Sugs, 09 Feb 2011 08:08:23 AM

Previous topic - Next topic

Sugs

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????? 


Arsenal

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