This is a migrated thread and some comments may be shown as answers.

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

4 Answers 108 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Mustafa
Top achievements
Rank 1
Mustafa asked on 16 Dec 2013, 08:47 AM
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 

4 Answers, 1 is accepted

Sort by
0
Mustafa
Top achievements
Rank 1
answered on 16 Dec 2013, 02:41 PM
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
0
Stef
Telerik team
answered on 16 Dec 2013, 07:09 PM
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

New HTML5/JS REPORT VIEWER with MOBILE AND TOUCH SUPPORT available in Telerik Reporting Q3 2013! Get the new Reporting version from your account or download a trial.

0
Mustafa
Top achievements
Rank 1
answered on 19 Dec 2013, 01:51 PM
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   
0
Stef
Telerik team
answered on 21 Dec 2013, 01:21 PM
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

New HTML5/JS REPORT VIEWER with MOBILE AND TOUCH SUPPORT available in Telerik Reporting Q3 2013! Get the new Reporting version from your account or download a trial.

Tags
General Discussions
Asked by
Mustafa
Top achievements
Rank 1
Answers by
Mustafa
Top achievements
Rank 1
Stef
Telerik team
Share this question
or