Oracle Data Source Fails RRS feed

  • Question

  • I have a Windows Server 2008/SQL 2008R2 server that has both the 32 bit and 64 bit Oracle 11g client installed.  Also we have TNS_ADMIN environment variable that points to a corporate location for all Oracle connections.  The problem I am having is I am trying to create a data source in Reporting Services that I cannot get a successful testing of the connection.  The error it keeps returning is "ORA-12154: TNS:could not resolve the connect identifier specified".  I have validated I can connect using SQL*PLUS and I also could successfully test an ODBC connection to this Oracle SID, I just cannot get it working in SSRS. 

    Any idea what the issue may be?

    Also, as a side note, we have a different Oracle connection in the same server that has a report on top of it that runs successfully althought that data source also fails the "Test Connection", which is very bizarre to me

    Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | BI Blitz

    Monday, April 29, 2013 6:30 PM

All replies