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
 
 
 
 
 
 
 
 

thayduckProgrammer AnalystAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

thayduckProgrammer AnalystAuthor Commented:
We had a extra ')' in the tnsname.org table.
Once that was removed problem went away.
I will close this questions.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jjozCommented:
so in this case it is really possible right to have connection to Oracle from SSRS ?
0
thayduckProgrammer AnalystAuthor 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
thayduckProgrammer AnalystAuthor Commented:
Our group has purchased SSRS.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.