Cannot open Oracle table in Report Designer / sqlDataSource and OracleClient Data Provider

1 Answer 13 Views
DataSource SQL Report Designer (standalone)
Martin
Top achievements
Rank 1
Martin asked on 04 Mar 2025, 03:42 AM

When using a certain table in the Standalone Report Designer I get an oci-22053-Error when loading data. It seems to be one of the float fields. When I exclude the field from my query, the error is not thrown.

Version is 19.0.25.211 .net Framework 4.6.2

1 Answer, 1 is accepted

Sort by
0
Todor
Telerik team
answered on 06 Mar 2025, 03:50 PM

Hello Martin,

The errors like the observed one are usually thrown by the ADO.NET provider specified in the SqlDataSource for making the connection to the database.

I guess the OracleClient Data Provider that you use doesn't support the field type or precision as elaborated in the following resources:

You may try another data provider for Oracle that supports the field type/precision or use the workarounds suggested in the above threads.

Regards,
Todor
Progress Telerik

Enjoyed our products? Share your experience on G2 and receive a $25 Amazon gift card for a limited time!

Tags
DataSource SQL Report Designer (standalone)
Asked by
Martin
Top achievements
Rank 1
Answers by
Todor
Telerik team
Share this question
or