Cannot connect to Oracle via SSRS Report Server

Posted on 2008-11-05
Last Modified: 2013-12-19
I can run my SSRS report (which accesses  2 Oracle tables) from my PC.
When I load .rdl to Report Server the report will not run and I get this error:

An error has occurred during report processing.
Cannot create a connection to data source 'sds_getpaid'.
ORA-12154: TNS:could not resolve service name

Dba's verified that the correct info is in the tnsnames.ora table on the report server.

 custom data source
 Connection type: Oracle  
Connection string:  Data Source=GETPAIDD.CN.CA  
A shared data source
 Select a shared data source    Specify a shared data source
A custom data source
 Connection string:  Data Source=GETPAIDD.CN.CA  
Connect using:
  Credentials stored securely in the report server
  User name:    XXXXXX
Password:       XXXXXX

Question by:thayduck

    Accepted Solution

    We had a extra ')' in the table.
    Once that was removed problem went away.
    I will close this questions.
    LVL 1

    Expert Comment

    so in this case it is really possible right to have connection to Oracle from SSRS ?

    Author Comment

    yes, I connect to Oracle tables in a sql 2005 stored procedure that is accessed  by a SSRS report.
    LVL 1

    Expert Comment

    thanks thayduck, is that using freeware SSRS or do you have to pay ?

    Author Comment

    Our group has purchased SSRS.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
    This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now