Error creating an Oracle DataSource "OCIEnvCreate failed with return code -1 but error message text was not available."

• Reg_Mayfield

  SSCrazy

  Points: 2661

  More actions

  July 11, 2013 at 8:37 am

  #280222

  I have a new Report Server installation 2012 and have been moving my reports from RS 2008 to this new installation. All my Sql Server reports have moved over just fine. Since I had reports that pulled data from a Oracle Database I installed a Oracle 11g client and tested using SQL Plus. I can connect to the Oracle Database with SQL Plus and run queries without any problems. I then tried to create an Oracle Datasource which I will need for my Oracle reports. When I test the connection I get the error :

  OCIEnvCreate failed with return code -1 but error message text was not available.

  I have Googled the error but have not found anything that has been useful. Any help in pointing me in the right direction would be greatly appreciated...

• vanu

  Newbie

  Points: 5

  More actions

  May 31, 2019 at 2:42 am

  #3648790

  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