• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1146
  • Last Modified:

Cannot connect to Oracle via SSRS Report Server

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
 
 
 
 
 
 
 
 

0
thayduck
Asked:
thayduck
  • 3
  • 2
1 Solution
 
thayduckAuthor Commented:
We had a extra ')' in the tnsname.org table.
Once that was removed problem went away.
I will close this questions.
0
 
jjozCommented:
so in this case it is really possible right to have connection to Oracle from SSRS ?
0
 
thayduckAuthor Commented:
yes, I connect to Oracle tables in a sql 2005 stored procedure that is accessed  by a SSRS report.
0
 
jjozCommented:
thanks thayduck, is that using freeware SSRS or do you have to pay ?
0
 
thayduckAuthor Commented:
Our group has purchased SSRS.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now