June 8, 2011 at 12:15 pm
Hi,
I am getting the error message while viewing from http://localhost/reports after deploying the ssrs reports which has been created using the Oracle Source to pull the data from oracle 10g server.
The error message follows
An error has occurred during report processing.Cannot create a connection to data source Oracle.OCIEnvCreate failed with return code -1 but error message text was not available.
Pls help me to resolve this issue.
Thanks in Advance.
June 9, 2011 at 7:07 am
Has anyone come across such a problem ?
June 9, 2011 at 10:49 am
Apparently not if they haven't posted a reply.
Two suggestions for you.
1) Google the error message.
2) Make sure you can connect to your data source outside of the report using the same user name and password the report has. I'm betting it's a security issue on Oracle's side. But this is a W.A.G. on my part because I don't know Oracle.
July 13, 2011 at 10:25 am
I am getting the same error too, right now, and also searching for a fix.
I'm in the BIDS designer and while simply testing the connection I get this error, "OCIEnvCreate failed with return code -1 but error message text was not available".
The following link makes it sound like a permission issue on the Oracle folder.
I tried changing permissions but it did not solve it for me. Maybe I didn't get the steps right...
I've read another link discussing this error and it seemed to indicate there may be a fix in a newer version of the oracle 10g connection client software. That's what I think I'll try next.
July 13, 2011 at 11:24 am
Just solved it for me with these steps...
1. Uninstalled all Oracle products.
2. Deleted the Oracle directory, (since the Oracle uninstaller did not do so).
3. Visited here http://www.oracle.com/technetwork/database/10203vista-087538.html
4. Downloaded the appropriate version for my 32-bit Windows 7 of the "Oracle Database 10g Client Release 2 (10.2.0.3)".
5. Installed using the Administrator option set (probably doesn't matter which install option set you choose).
Noticed that during the install, the scrolling log section mentioned applying patch/fixes. So I'm guessing that the original Oracle 10g client connection software that I installed was missing whatever this patch was...
Without even rebooting, I tested the connection using several non-Oracle tools and it now works. Hope that is a help.
July 13, 2011 at 11:39 am
Thanks for posting your solution, Erik. That will help.
May 31, 2019 at 2:41 am
Hi, I was getting same error when I was trying to create SSRS datasource (SQL RS 2012) to Oracle database. And in my case I found that there were two instances of Oracle client installed on SSRS (SQL Reporting Service) server i.e.
1st Installation (main) at C:\Oracle\*
2nd Installation at C:\Program Files\Oracle*
I resolved this error by uninstalling 2nd Oracle client installation using Oracle Universal Installer utility on SSRS server. I believe when SSRS trying to look for TNSNAMES.ORA file it was not able to refer due to two set of Oracle client.
Thanks,
Ash
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply