Windows Vista Beta | WinVistaBeta.com - Message | DataSet (designer), Report (MS) and custom connections

November 20, 2008  
Subject: DataSet (designer), Report (MS) and custom connections
Group: microsoft.public.vstudio.development,microsoft.public.vstudio.general
Date: 8/29/2008 2:28:02 PM
From: "Arthur Dent" [Email Address Protection]

Hello all...

I have a website to which I want to add some reporting ability using the MS
reporting tools. (local, not RS)
When you add a new DataSet (TableAdapter) it want's to establish a new,
direct connection to a database.
When you add a report, to design it you need a direct database connection.

However, in our app, we have a class which manages and hands out
connections, based on the currently logged in user (using login names to
SQL, to allow for auditing).

How can I get DataSets/TableAdapters, and MS local reports to use a
connection object as handed out by my centralized class instead of wanting
to directly establish their own connections?

Thanks in advance, ...
- Arthur Dent.


Back