Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
marktheman
Starting Member
2 Posts |
 Posted - 2007-09-03 : 12:44:07
|
| Hi,I'm new to SSRS but have a problem connecting to Oracle. I have placed my reports upon a reporting server but the shared data connection isn't working and I'm confused as to why. I have specified the name, connection type as "Oracle", set the correct user id and password for the credentials and the connection string as for example 'Data Source=oracleExample;Unicode="True"'. I also have set the correct entry in the tnsnames.ora file for this datasource, example:"oracleExample = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 12.23.45.23)(PORT = 3425)) ) (CONNECT_DATA = (SID = oracle) ) )"Unfortunately I receive the following error when trying to connect." An error has occurred during report processing. Cannot create a connection to data source 'oracleDataSource'. For more information about this error navigate to the report server on the local server machine, or enable remote errors "I'm mystified as to what the issue is. Any ideas? Would restarting the report server pick up the tnsnames.ora file? I have this working locally using report designer.Any help, much appreciated. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-03 : 12:59:58
|
| Installed Oracle client on RS machine? |
 |
|
|
|
|
|
problem using oracle data source from SSRS