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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
jjoz
so in this case it is really possible right to have connection to Oracle from SSRS ?
ASKER
yes, I connect to Oracle tables in a sql 2005 stored procedure that is accessed by a SSRS report.
thanks thayduck, is that using freeware SSRS or do you have to pay ?
ASKER
Our group has purchased SSRS.