Data Processing Extensions and Data Sources

Anyone know about DPE? Specifically, I want to know if it can help me to
make a data source dynamic in a multi-user environment.
I need to integrate SRS into my web app, which allows the user to select a
database from a list before running a report. Several people could try to
run the same report at the same time. If I use the API
"SetDataReportSources" then this switches the data source for all users of
the report. As noted before in this group, this is a limitation of SQL RS.
What I really want to know is: Can I develop a DPE that allows me to
dynamically set the data source at run-time? This is a requirement for my
application, and I want to avoid creating multiple copies of reports or
passing the data source in a stored procedure. Either of these work-arounds
involve more maintenance and hassle for the future. Can DPE allow me to make
a permanent solution?
I looked in the books online, and read about implementing a connection
class. If I made my own connection object, could I set it dynamically at run
time?
Hopefully,
MalikI'm trying to do the same thing as well but we havn't had the time or
resource yet to finish it off. Once I have a DPE running I would be happy to
share it on gotdotnet. Or if you get there first maybe you could to.
Try this link for further info. This is where I got started. I have aslo
uploaded some VB code to Gavin's page to complement the C# he has already.
It's still not as straight forward as you might hope but it will acomplish
what you are after.
http://weblogs.asp.net/gavinjoyce/archive/2004/01/29/64339.aspx?Pending=true
Regards
Toby,.
"Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
news:O4sJVKDZEHA.556@.tk2msftngp13.phx.gbl...
> Anyone know about DPE? Specifically, I want to know if it can help me to
> make a data source dynamic in a multi-user environment.
> I need to integrate SRS into my web app, which allows the user to select a
> database from a list before running a report. Several people could try to
> run the same report at the same time. If I use the API
> "SetDataReportSources" then this switches the data source for all users of
> the report. As noted before in this group, this is a limitation of SQL RS.
> What I really want to know is: Can I develop a DPE that allows me to
> dynamically set the data source at run-time? This is a requirement for my
> application, and I want to avoid creating multiple copies of reports or
> passing the data source in a stored procedure. Either of these
work-arounds
> involve more maintenance and hassle for the future. Can DPE allow me to
make
> a permanent solution?
> I looked in the books online, and read about implementing a connection
> class. If I made my own connection object, could I set it dynamically at
run
> time?
> Hopefully,
> Malik
>

Data Mapping

I'm looking for a tool to make a graphical representation of my MS SQL
databases. specifically, I was hoped to find something that could show the
fields in the tables of all the databases on an MS SQL server.
Anybody know an application that can do that?
Visio for enterprise architects
ERwin
"mindjuju" <mindjuju@.discussions.microsoft.com> wrote in message
news:71D75768-1B7E-4F06-8315-203D86FFAA8E@.microsoft.com...
> I'm looking for a tool to make a graphical representation of my MS SQL
> databases. specifically, I was hoped to find something that could show
> the
> fields in the tables of all the databases on an MS SQL server.
> Anybody know an application that can do that?
|||Hi,
You can use SQL Server Diagrams using Enterprise manager or else you can use
Erwin. Erwin will give you the Physical and Logical model of
your database.
Thanks
Hari
SQL Server MVP
"mindjuju" <mindjuju@.discussions.microsoft.com> wrote in message
news:71D75768-1B7E-4F06-8315-203D86FFAA8E@.microsoft.com...
> I'm looking for a tool to make a graphical representation of my MS SQL
> databases. specifically, I was hoped to find something that could show
> the
> fields in the tables of all the databases on an MS SQL server.
> Anybody know an application that can do that?
|||or ER-Studio
Greg Jackson
Pdx, Oregon