How to dynamically change a datasource in SSRS (MS SQL 2008)

Posted on 2011-10-03
Last Modified: 2012-08-14
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

Question by:OliShim
    LVL 9

    Expert Comment

    by:Evan Cutler

    Author Comment

    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

    Accepted Solution

    I was able to get this to work. What you must select 'no credentials' on the datasource 'credentials...
    Otherwise it will always look in 'credentials' instead of taking the ones entered in the connection string.

    Author Closing Comment

    Other solution was only partial

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now