Showing posts with label designer. Show all posts
Showing posts with label designer. Show all posts

Thursday, March 8, 2012

Change TIME OUT on Qry?

Below is my error msg. I am trying to save updates made to a table in the designer. my connection time out is set to 0 but i am still getting this msg:

/*
Tuesday, March 28, 20066:32:46 PM
User:
Server: EVILONE
Database: DMS
Application:
*/

'Detail' table
- Unable to modify table.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.Is the table in use? Could somebody have it open? Check the current processes.|||No the db is on my laptop and i am the only

Sunday, February 12, 2012

Change OracleDataAdapter property

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?