Home

Products
       NCAA Tourney
       Loan Calculator
       Text / HTML Versioner
       HTML Fader
       HTML Scheduler
       SQL Reporting Services
       MySkype

Support & Forums
Thursday, February 09, 2012 You Are Here: Support & Forums  | 
Welcome to Module Masters support forums - the primary support mechanism for our products. Feel free to post your questions, and we will aim to respond in a timely manner.  We also encourage our users to post any feedback you may have.  You may also email us directly at service@modulemasters.com
Forums > Module Masters Forum > SQL Reporting Services
Subject: Dynamic Connection String
Prev Next
You are not authorized to post a reply.

Author Messages
McCoyUser is Offline

Posts:3
09/25/2008 15:42  
We are urgently looking for a reporting module for our web based solution. We have a number of clients that run a shared application on our central web server. Each client has its own database on the server. There is only have one instance of DotNetNuke installed on the server. The connection string and database name for the user that is currently logged in are retrieved from a database table. Does your reporting solution allow one to dynamically change the connection string at runtime? In other words, we develop a common (shared) report using our sample database and then deploy the report to the web server. When the client runs the report, it 'refreshes' the report by connecting to the relevant client's database (done by dynamically passing the right connection string/database name to the reporting module). Possible?
hostUser is Offline

Posts:497
09/25/2008 23:49  
Well, this module requires that you have SQL Reporting Services setup somewhere. This is a reporting solution built into microsoft's SQL Server. Do you already have this setup? It may be possible with some tweaking to setup something so it acts as dynamic as you want it to, assuming you are using SQL RS.
McCoyUser is Offline

Posts:3
09/26/2008 03:58  
yes, we're using RS.
hostUser is Offline

Posts:497
09/26/2008 08:25  
Ok, then you can use our module in conjunction with a method such as this:
http://www.simple-talk.com/community/forums/post/2735.aspx
McCoyUser is Offline

Posts:3
09/29/2008 15:29  
Thank you!
You are not authorized to post a reply.
Forums > Module Masters Forum > SQL Reporting Services > Dynamic Connection String


ActiveForums 3.7
Copyright 2011 by Module Masters Privacy StatementTerms Of Use