Avatar of OliShim
OliShim
 asked on

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:

="Data Source="&Parameters!Source&";User Id=MyId;Password=MyPassword;"

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

Olivier
Microsoft SQL ServerOracle Database

Avatar of undefined
Last Comment
OliShim

8/22/2022 - Mon
OliShim

ASKER
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
ASKER CERTIFIED SOLUTION
OliShim

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
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.
ask a question
OliShim

ASKER
Other solution was only partial
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck