Dynamicaly switching between 2 datasources for a report in order to switch between the pro

I have 2 datasources, one for the production and one for the development
database and I use 'SetReportDataSources' to switch between the 2
datasources. Unfortunately 'SetReportDataSources' permanently switches the
datasource for the report on the Report Server. So, if before the 'Render
gets called another process switches the datasource for that report, the 1st
one would run with the wrong datasource.
Anyone know any way to do this without having to write a custom 'Data
Processing Extension'?
Thanks,
TirdadHello MSFT,
I was wondering if someone from Reporting Services or SQL Server would
address my question?
Sincerely,
Tirdad Lohrasb.
"Tirdad Lohrasb" <tlohrasb@.unex.ucla.edu> wrote in message
news:u5pydd%23UEHA.3012@.tk2msftngp13.phx.gbl...
> I have 2 datasources, one for the production and one for the development
> database and I use 'SetReportDataSources' to switch between the 2
> datasources. Unfortunately 'SetReportDataSources' permanently switches the
> datasource for the report on the Report Server. So, if before the 'Render
> gets called another process switches the datasource for that report, the
1st
> one would run with the wrong datasource.
> Anyone know any way to do this without having to write a custom 'Data
> Processing Extension'?
> Thanks,
> Tirdad
>|||The answer is no, dynamic connection strings are not supported. Several
workarounds have previously been proposed in the newsgroup.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tirdad Lohrasb" <tlohrasb@.unex.ucla.edu> wrote in message
news:%23t5DmS%23VEHA.208@.TK2MSFTNGP10.phx.gbl...
> Hello MSFT,
> I was wondering if someone from Reporting Services or SQL Server would
> address my question?
> Sincerely,
> Tirdad Lohrasb.
>
> "Tirdad Lohrasb" <tlohrasb@.unex.ucla.edu> wrote in message
> news:u5pydd%23UEHA.3012@.tk2msftngp13.phx.gbl...
> > I have 2 datasources, one for the production and one for the development
> > database and I use 'SetReportDataSources' to switch between the 2
> > datasources. Unfortunately 'SetReportDataSources' permanently switches
the
> > datasource for the report on the Report Server. So, if before the
'Render
> > gets called another process switches the datasource for that report, the
> 1st
> > one would run with the wrong datasource.
> > Anyone know any way to do this without having to write a custom 'Data
> > Processing Extension'?
> >
> > Thanks,
> > Tirdad
> >
> >
>|||Thank you with the response back. Now, I have 2 questions, 1. Is there any
plan to support dynamic connections in the future.
2. Can you tell me what the workarounds are? The only one I can think of is
writing custom Data Processing Extension, Is this
the around?
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:O22HW9BWEHA.2716@.tk2msftngp13.phx.gbl...
> The answer is no, dynamic connection strings are not supported. Several
> workarounds have previously been proposed in the newsgroup.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Tirdad Lohrasb" <tlohrasb@.unex.ucla.edu> wrote in message
> news:%23t5DmS%23VEHA.208@.TK2MSFTNGP10.phx.gbl...
> > Hello MSFT,
> >
> > I was wondering if someone from Reporting Services or SQL Server would
> > address my question?
> >
> > Sincerely,
> > Tirdad Lohrasb.
> >
> >
> > "Tirdad Lohrasb" <tlohrasb@.unex.ucla.edu> wrote in message
> > news:u5pydd%23UEHA.3012@.tk2msftngp13.phx.gbl...
> > > I have 2 datasources, one for the production and one for the
development
> > > database and I use 'SetReportDataSources' to switch between the 2
> > > datasources. Unfortunately 'SetReportDataSources' permanently switches
> the
> > > datasource for the report on the Report Server. So, if before the
> 'Render
> > > gets called another process switches the datasource for that report,
the
> > 1st
> > > one would run with the wrong datasource.
> > > Anyone know any way to do this without having to write a custom 'Data
> > > Processing Extension'?
> > >
> > > Thanks,
> > > Tirdad
> > >
> > >
> >
> >
>|||1. Yes, dynamic connection strings will be included in the SQL 2005 version.
2. You can write a stored procedure that uses other databases on the same
box, use OPENROWSET, or use linked servers
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tirdad Lohrasb" <tlohrasb@.unex.ucla.edu> wrote in message
news:%23U2wbvGWEHA.3524@.TK2MSFTNGP12.phx.gbl...
> Thank you with the response back. Now, I have 2 questions, 1. Is there any
> plan to support dynamic connections in the future.
> 2. Can you tell me what the workarounds are? The only one I can think of
> is
> writing custom Data Processing Extension, Is this
> the around?
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:O22HW9BWEHA.2716@.tk2msftngp13.phx.gbl...
>> The answer is no, dynamic connection strings are not supported. Several
>> workarounds have previously been proposed in the newsgroup.
>> --
>> Brian Welcker
>> Group Program Manager
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Tirdad Lohrasb" <tlohrasb@.unex.ucla.edu> wrote in message
>> news:%23t5DmS%23VEHA.208@.TK2MSFTNGP10.phx.gbl...
>> > Hello MSFT,
>> >
>> > I was wondering if someone from Reporting Services or SQL Server would
>> > address my question?
>> >
>> > Sincerely,
>> > Tirdad Lohrasb.
>> >
>> >
>> > "Tirdad Lohrasb" <tlohrasb@.unex.ucla.edu> wrote in message
>> > news:u5pydd%23UEHA.3012@.tk2msftngp13.phx.gbl...
>> > > I have 2 datasources, one for the production and one for the
> development
>> > > database and I use 'SetReportDataSources' to switch between the 2
>> > > datasources. Unfortunately 'SetReportDataSources' permanently
>> > > switches
>> the
>> > > datasource for the report on the Report Server. So, if before the
>> 'Render
>> > > gets called another process switches the datasource for that report,
> the
>> > 1st
>> > > one would run with the wrong datasource.
>> > > Anyone know any way to do this without having to write a custom
>> > > 'Data
>> > > Processing Extension'?
>> > >
>> > > Thanks,
>> > > Tirdad
>> > >
>> > >
>> >
>> >
>>
>|||I have released a DPE that achiveves this. It can be downloaded at
http://workspaces.gotdotnet.com/appworld
Regards
Toby
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:uVohOYBVEHA.2360@.TK2MSFTNGP10.phx.gbl...
> why you don't change the datasource definition after your deployment?
> you can create the report in visual studio using a specific server, and,
> after the first deployment, change the server on report server. Your
> published reports will used the production server, and the development in
> visual studio used the dev. server.
>
> "Tirdad Lohrasb" <tlohrasb@.unex.ucla.edu> a écrit dans le message de
> news:u5pydd%23UEHA.3012@.tk2msftngp13.phx.gbl...
> > I have 2 datasources, one for the production and one for the development
> > database and I use 'SetReportDataSources' to switch between the 2
> > datasources. Unfortunately 'SetReportDataSources' permanently switches
the
> > datasource for the report on the Report Server. So, if before the
'Render
> > gets called another process switches the datasource for that report, the
> 1st
> > one would run with the wrong datasource.
> > Anyone know any way to do this without having to write a custom 'Data
> > Processing Extension'?
> >
> > Thanks,
> > Tirdad
> >
> >
>|||Hi Toby,
when I try to download your sample I get the following popup:
"Operation could not be completed. Some resource(s) may have been removed."
I have installed the GOTDOTNET workspaces.
Regards,
Peter.
"Toby" wrote:
> I have released a DPE that achiveves this. It can be downloaded at
> http://workspaces.gotdotnet.com/appworld
> Regards
> Toby
> "Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
> news:uVohOYBVEHA.2360@.TK2MSFTNGP10.phx.gbl...
> > why you don't change the datasource definition after your deployment?
> > you can create the report in visual studio using a specific server, and,
> > after the first deployment, change the server on report server. Your
> > published reports will used the production server, and the development in
> > visual studio used the dev. server.
> >
> >
> > "Tirdad Lohrasb" <tlohrasb@.unex.ucla.edu> a écrit dans le message de
> > news:u5pydd%23UEHA.3012@.tk2msftngp13.phx.gbl...
> > > I have 2 datasources, one for the production and one for the development
> > > database and I use 'SetReportDataSources' to switch between the 2
> > > datasources. Unfortunately 'SetReportDataSources' permanently switches
> the
> > > datasource for the report on the Report Server. So, if before the
> 'Render
> > > gets called another process switches the datasource for that report, the
> > 1st
> > > one would run with the wrong datasource.
> > > Anyone know any way to do this without having to write a custom 'Data
> > > Processing Extension'?
> > >
> > > Thanks,
> > > Tirdad
> > >
> > >
> >
> >
>
>|||I go to the URL, but I don't see anything to download
"Toby" wrote:
> I have released a DPE that achiveves this. It can be downloaded at
> http://workspaces.gotdotnet.com/appworld
> Regards
> Toby
> "Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
> news:uVohOYBVEHA.2360@.TK2MSFTNGP10.phx.gbl...
> > why you don't change the datasource definition after your deployment?
> > you can create the report in visual studio using a specific server, and,
> > after the first deployment, change the server on report server. Your
> > published reports will used the production server, and the development in
> > visual studio used the dev. server.
> >
> >
> > "Tirdad Lohrasb" <tlohrasb@.unex.ucla.edu> a écrit dans le message de
> > news:u5pydd%23UEHA.3012@.tk2msftngp13.phx.gbl...
> > > I have 2 datasources, one for the production and one for the development
> > > database and I use 'SetReportDataSources' to switch between the 2
> > > datasources. Unfortunately 'SetReportDataSources' permanently switches
> the
> > > datasource for the report on the Report Server. So, if before the
> 'Render
> > > gets called another process switches the datasource for that report, the
> > 1st
> > > one would run with the wrong datasource.
> > > Anyone know any way to do this without having to write a custom 'Data
> > > Processing Extension'?
> > >
> > > Thanks,
> > > Tirdad
> > >
> > >
> >
> >
>
>