I am getting the following error when trying to run a query against an Oracle DB.
"TITLE: Microsoft Report Designer
An error occurred while reading data from the query result set.
OCI-22053: overflow error
ADDITIONAL INFORMATION:
OCI-22053: overflow error
(System.Data.OracleClient)"
The fix is...
set the ReturnProviderSpecificTypes property of the OracleDataAdapter to true and have it read OracleNumber's instead of System.Decimal, which can't handle the value
I need to know How I can do this.
Using BI tools in sql server 2005
Resolved this by creating the report without previewing then opened the .rdl file in my xml editor and changed the typename value for each System.Decimal
' <rd:TypeName>System.Decimal</rd:TypeName>' to ' <rd:TypeName>OracleNumbers</rd:TypeName>'
then saved as .rdl and opened in reporting services and previewed and works just fine.
|||I'm having a similar issue but I'm processing the cube in a Visual Studio project. Can I make the data type change within the Analysis Services project somewhere?
