"Roberto Souza" <roberto_tbabh@hotmail.com> wrote in message
news:u1QHf1fiEHA.1652@TK2MSFTNGP09.phx.gbl...
> Hi, I'm trying to use an UDL file to make easier to manage my connections
on
> RS like I'm using on SQL DTS packages.
> Problem is: RS is not reading the password stored at the UDL file.
> Did anybody did it with sucess? I'd like RS to read all the connection
info
> (server, db, user and password) from the UDL file and ask no parameters
from
> the user.
>
> TIA,
>
> Roberto.
>
>

"Roberto Souza" <roberto_tbabh@hotmail.com> wrote in message
news:%23V92HLgiEHA.712@TK2MSFTNGP09.phx.gbl...
> Thaks Bruce, but something like UDLs would be the perfect solution to me
> because it would avoid any additional work the deploying the report when
> moving from test to development to production server; it would also avoid
me
> to tell to the report programmer any passwords.
> Any other clue?
>
> Info: I'm creating a report using OLEDB for DB2 (DB2 at the mainframe)
>
> TIA,
>
> Roberto Souza.
>
> "Bruce Loehle-Conger" <bruce_lcNOSPAM@hotmail.com> wrote in message
> news:OUpc9$fiEHA.4092@TK2MSFTNGP10.phx.gbl...
> > I did not find anyway to do as you want. What I have found is that you
> need
> > to specify the user credentials to use in the definition of the data
> source.
> > I use shared data sources and a dsn file (in my case I am going against
an
> > ODBC data source). I specify to use Credentials Stored Securely in the
> > report server. If you used shared datasources then this is not too
> > burdensome.
> >
> > Bruce L-C
> >
> > "Roberto Souza" <roberto_tbabh@hotmail.com> wrote in message
> > news:u1QHf1fiEHA.1652@TK2MSFTNGP09.phx.gbl...
> > > Hi, I'm trying to use an UDL file to make easier to manage my
> connections
> > on
> > > RS like I'm using on SQL DTS packages.
> > > Problem is: RS is not reading the password stored at the UDL file.
> > > Did anybody did it with sucess? I'd like RS to read all the connection
> > info
> > > (server, db, user and password) from the UDL file and ask no
parameters
> > from
> > > the user.
> > >
> > > TIA,
> > >
> > > Roberto.
> > >
> > >
> >
> >
>
>

"Bruce Loehle-Conger" <bruce_lcNOSPAM@hotmail.com> wrote in message
news:OUpc9$fiEHA.4092@TK2MSFTNGP10.phx.gbl...
> I did not find anyway to do as you want. What I have found is that you
need
> to specify the user credentials to use in the definition of the data
source.
> I use shared data sources and a dsn file (in my case I am going against an
> ODBC data source). I specify to use Credentials Stored Securely in the
> report server. If you used shared datasources then this is not too
> burdensome.
>
> Bruce L-C
>
> "Roberto Souza" <roberto_tbabh@hotmail.com> wrote in message
> news:u1QHf1fiEHA.1652@TK2MSFTNGP09.phx.gbl...
> > Hi, I'm trying to use an UDL file to make easier to manage my
connections
> on
> > RS like I'm using on SQL DTS packages.
> > Problem is: RS is not reading the password stored at the UDL file.
> > Did anybody did it with sucess? I'd like RS to read all the connection
> info
> > (server, db, user and password) from the UDL file and ask no parameters
> from
> > the user.
> >
> > TIA,
> >
> > Roberto.
> >
> >
>
>