Data Source access

Hi All,
I'm looking to create an ad-hoc query generator so that I can create a
report on the fly, but I would like to use RS Shared Data Sources for this.
I have run into a problem though, in that I can't retrieve the password for
the Shared Data Source. Is there any way to get the Data Source back as a
connection to the database in ADO?
Thanks in advacne,
CathieNo you cannot get the data source back as connection. But you could try to
implement a custom RS data extension and use it then in the shared data
source.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cathie" <cathie@.somewhere.com> wrote in message
news:eqY8s64SFHA.2128@.TK2MSFTNGP14.phx.gbl...
> Hi All,
> I'm looking to create an ad-hoc query generator so that I can create a
> report on the fly, but I would like to use RS Shared Data Sources for
> this. I have run into a problem though, in that I can't retrieve the
> password for the Shared Data Source. Is there any way to get the Data
> Source back as a connection to the database in ADO?
> Thanks in advacne,
> Cathie
>|||Hi Robert,
I'm sorry I don't understand how a custom RS data extension would help me.
I am want to be able to get any datasource's (within RS) tables, views,
stored procedures etc. How would a custom RS data extension help?
Cathie
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:OIBjdIgTFHA.1404@.TK2MSFTNGP09.phx.gbl...
> No you cannot get the data source back as connection. But you could try to
> implement a custom RS data extension and use it then in the shared data
> source.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Cathie" <cathie@.somewhere.com> wrote in message
> news:eqY8s64SFHA.2128@.TK2MSFTNGP14.phx.gbl...
>> Hi All,
>> I'm looking to create an ad-hoc query generator so that I can create a
>> report on the fly, but I would like to use RS Shared Data Sources for
>> this. I have run into a problem though, in that I can't retrieve the
>> password for the Shared Data Source. Is there any way to get the Data
>> Source back as a connection to the database in ADO?
>> Thanks in advacne,
>> Cathie
>|||If you go through a custom data extension, you would need to implement our
IDBConnection etc. interfaces. Hence, in the custom data extension you would
see the actual connection string etc. used to connect to the data source.
You could use this information to do then some adhoc query generation. What
I'm basically saying is that you cannot easily do the adhoc query generation
from within the report in RS 2000.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cathie" <cathie@.somewhere.com> wrote in message
news:e5GQ9F4TFHA.2712@.TK2MSFTNGP09.phx.gbl...
> Hi Robert,
> I'm sorry I don't understand how a custom RS data extension would help me.
> I am want to be able to get any datasource's (within RS) tables, views,
> stored procedures etc. How would a custom RS data extension help?
> Cathie
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:OIBjdIgTFHA.1404@.TK2MSFTNGP09.phx.gbl...
>> No you cannot get the data source back as connection. But you could try
>> to implement a custom RS data extension and use it then in the shared
>> data source.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Cathie" <cathie@.somewhere.com> wrote in message
>> news:eqY8s64SFHA.2128@.TK2MSFTNGP14.phx.gbl...
>> Hi All,
>> I'm looking to create an ad-hoc query generator so that I can create a
>> report on the fly, but I would like to use RS Shared Data Sources for
>> this. I have run into a problem though, in that I can't retrieve the
>> password for the Shared Data Source. Is there any way to get the Data
>> Source back as a connection to the database in ADO?
>> Thanks in advacne,
>> Cathie
>>
>