Connection Pooling for Data-Driven Subscriptions?

Is there any way to get a data-driven subscription to share the DB
Connection between iterrations?
The behaviour we're seeing currently is a new connection being opened/closed
for each report delivered by our data-driven subscription. This is impacting
our server perf.
Suggestions? Pointers?
Did I miss anything in the docs?
TIAAre they all using the same credentials?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Paul Enfield" <penfield@.paraport.com> wrote in message
news:uFipWYyVFHA.3588@.TK2MSFTNGP10.phx.gbl...
> Is there any way to get a data-driven subscription to share the DB
> Connection between iterrations?
> The behaviour we're seeing currently is a new connection being
opened/closed
> for each report delivered by our data-driven subscription. This is
impacting
> our server perf.
> Suggestions? Pointers?
> Did I miss anything in the docs?
> TIA
>

Connection and /share file and printer/ option in Windows firewall

Hello
Is there any relation between SQL2005 connection and /share file and
printer/ option in Windows firewall?
When I check the option I can connect from remote client via script, while
not that when I unchecked the option.
I can't easily believe the two entities are related. I checked over and over
again...
If my script matters,
set con=createobject("adodb.connection")
login3="provider=SQLOLEDB; server=w3a; Initial Catalog=air;
Trusted_connection=yes; "
con.open login3
msgbox con.stateOn Dec 26 2006, 2:18 pm, "Han" <hp4...@.kornet.net.korea> wrote:
> Hello
> Is there any relation between SQL2005 connection and /share file andprinte
r/ option in Windows firewall?
> When I check the option I can connect from remote client via script, while
> not that when I unchecked the option.
> I can't easily believe the two entities are related. I checked over and ov
er
> again...
> If my script matters,
> set con=createobject("adodb.connection")
> login3="provider=SQLOLEDB; server=w3a; Initial Catalog=air;
> Trusted_connection=yes; "
> con.open login3
> msgbox con.state
I again experiencde same phenomena? Do anyone know about that?

Connection and /share file and printer/ option in Windows firewall

Hello
Is there any relation between SQL2005 connection and /share file and
printer/ option in Windows firewall?
When I check the option I can connect from remote client via script, while
not that when I unchecked the option.
I can't easily believe the two entities are related. I checked over and over
again...
If my script matters,
set con=createobject("adodb.connection")
login3="provider=SQLOLEDB; server=w3a; Initial Catalog=air;
Trusted_connection=yes; "
con.open login3
msgbox con.state
On Dec 26 2006, 2:18 pm, "Han" <hp4...@.kornet.net.korea> wrote:
> Hello
> Is there any relation between SQL2005 connection and /share file andprinter/ option in Windows firewall?
> When I check the option I can connect from remote client via script, while
> not that when I unchecked the option.
> I can't easily believe the two entities are related. I checked over and over
> again...
> If my script matters,
> set con=createobject("adodb.connection")
> login3="provider=SQLOLEDB; server=w3a; Initial Catalog=air;
> Trusted_connection=yes; "
> con.open login3
> msgbox con.state
I again experiencde same phenomena? Do anyone know about that?