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 |
|
swenri
Yak Posting Veteran
72 Posts |
 Posted - 2009-06-02 : 17:44:29
|
| I have created a bunch of reports in MS Visual Studio and they run fine when I connect through VS. However when I deploy them (along with the same datasource) to my local Sql Server Reporting Server instances and try and run them I get the following error:* An error has occurred during report processing.Cannot create a connection to data source 'testdatasource'.ORA-12154: TNS:could not resolve the connect identifier specifiedI can connect to the Oracle server through SQL client also, so I think it is something to do with SSRS. I use OLEDB provider MSDAORA(Microsoft provider for Oracle) to connect.Any help is appreciated.Thank you, |
|
|
|
|
|
Connecting to Oracle 10g though SSRS 2005