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

Handling MYSQL textblobs in Framework Manager

Started by JGirl, 05 Sep 2005 06:47:04 PM

Previous topic - Next topic

JGirl

Hi,

Has anyone had experience with ReportNet reporting from MYSQL?

I tried to create a basic framework on top of the bugzilla schema (the database is MYSQL, and im using the mysql odbc driver), and any SQL that contains a "textblob" type column is not executable.  Anyone have ideas for how to get around this?

When you report off a real database (eg, oracle) and you try to include a blob in the framework, it runs the queries and just includes [blob] in the test data.

The problem here is that I need to report off some of the columns that are textblobs.

J