How to dynamically change a datasource in SSRS (MS SQL 2008)
I am looking to dynamically change a datasource in SSRS (Sql Server Reporting Services) to connect to either one of 2 Oracle databases, based on a parameter.
I use the function icon when setting up my datasource, and enter the following function:
The parameter source contains the TNS Name of my Oracle database
When I run the report, I get an error "Can not create connection to datasource, null password given, logon denied"...
So SSRS sees my connection string, but for some reason is not able to parse the username and password...
Thank you
I tried the information from the links, but I can not pass a username and password for an Oracle connection...
I get the message indicated in my original post
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/one-report-for-many-instances-dyanmicall
http://www.sqlservercentral.com/articles/Development/2945/
http://wiki.softartisans.com/display/BLOGS/2011/04/19/How+to+create+a+dynamic+Reporting+Services+shared+data+source+using+linked+servers
Cheers.