January 24, 2012 at 12:44 pm
Guys I'm having a strange problem with SQL Server 2008 reporting services one of our programmers is trying to run a report that is connected to an Oracle data source. Whenever we try to run the report from our test workstation we recieve error " An error has occured during report processing (rserroropeningconnection). Now the funny thing is this report will preview fine in BIDS the problem occurs when deploying to the report server. I've installed 32 bit and 64 bit Oracle drivers on the reporting sever to be exact I installed Oracle 11.1.0.7.0 clients I also even installed 32 bit Oracle Data Access components for Visual Studio. So as of write now each Oracle install is in its on dedicated directory with the correct tnsnames I even granted the report server service account full access to the orahome. I can create a udl file and connect into the Oracle server via OLEDB or ODBC. Now this is where it gets interesting I logged into the report server and ran the report this time I get a totally different error than when I'm logged in on a test workstation the error is "Cannot create a connection to data source ORA-01017: invalid username/password; logon denied. So my question is where am I going wrong I actually thought about just doing a db link to the Oracle server than creating views for the Oracle tables and referencing those tables via SSRS.
January 24, 2012 at 12:52 pm
I think I'd go the linked server route.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply