Unknown SQL type - -98( because of Blob data from db2)

[Mustafa]

Hi all,

I use db2 database with Odbc data provider and Telerik Report Designer Q3 2013.
I have a table which has a blob data of a picture. When I tried to select it, I take an error  "Unknown SQL type - -98".
I can't find any documentation or solution about it. Can you please help?

Error Screen Shot

Thanks,
Mustafa 

[Mustafa]

Hi again, 

I learned ODBC data provider not support to BLOB data type,  so i'm trying to use Ole Db .NET  data provider for DB2. But there is a problem here too. I configure all setting and connection test is successful. but when i try to execute command, Telerik Report Designer suddenly give an error and closed. Sql is correct, I m sure of that. Do you have an idea about this problem?

Regard, 
Mustafa

[Stef]

Hello Mustafa,

The SqlDatSource component uses standard ADO.NET classes, the registered and set provider to connect and retrieve data. If the provider is properly registered and can work with IBM DB2 database, double-check if the connection string and the query are correct by loading a DataSet object for instance. Also check if the Ole DB Provider for DB2 you use supports your database version.

Regards,
Stef
Telerik

[Mustafa]

Hi Stef,
Thanks for reply,

Problem was fixed in very weird ways for two reports  have same problem.  
First report start working when I started telerik report designer with admin user with no change. But other report had same problem still.
Second report start working when I started 32 bit telerik report designer again with no change. Then other report had started to fail. After 2 or 3 try with no change, both of them was working. Now both are working finally but I can't understand what is problem or what is solution. I think Telerik Reporting with Ole Db can not work stable.

Thanks,
Mustafa   

[Stef]

Hi Mustafa,

If the provider is registered correctly on the machine it will be displayed in the list of available providers in the SqlDataSource Wizard. Then depending on the selected platform you can use the x86 or x64 Standalone Designer. Since that point we use standard ADO.NET classes to connect and retrieve data.

Regards,
Stef
Telerik