RE: Remote DB connection questions

Eric,

The user name and password you used to create the package are not used a
run time. The way to specify them is on your CONNECT statement in the
program. If you don't want to hardcode them in the program, you can put
them in a file or data area and use host variables to the CONNECT
statement.

As for the other users having problems, it's obviously a bug in the
program or an authority error. If they enter STRDBG UPDPROD(*YES) on the
command line before calling your program, their job logs will contain
all of the debugging output from the SQL runtime which will be useful in
figuring out what happened.

Matt

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Dalton, Eric
Sent: Monday, August 06, 2007 12:21 PM
To: 'rpg400-l@xxxxxxxxxxxx'
Subject: Remote DB connection questions

Hi all,
I'm using an SQLRPGLE program to connect between our test/production
partitions. The goal was to create a program that would run on either
box
while accessing only the data from Production all while not having to
hardcode a password into the program. I've almost gotten there using
CRTSQLPKG but have noticed one problem. I must be missing something
trivial
in how the RDB connections work. Here's the process I've been using for
testing:

I sign onto the Development box, compile the program with default
parameters
& CRTSQLPKG pointing to the Production partition using
username/password.
Running the program accesses data on the Production partition as it
should.
Good! The trouble is, when any other user runs the program they see data
on
the Development partition. It appears as though the only user who is
able to
fetch data from the remote DB is the one that created the package. How
can
this be the case?

Another question that came up is what happens if the password is changed
for
the user defined in the CRTSQLPKG command?
Thanks in advance,

Eric Dalton
Waterford Wedgwood USA


**********************************************************************
This Transmission may contain Privileged and Confidential Information
intended only for the use of the named addressee(s). If you are not the
intended recipient, You Are Hereby Notified that any dissemination of
this communication is strictly prohibited.

If you have received this Transmission in error please notify us and
return to Waterford Wedgwood, USA immediately.

Waterford Wedgwood, USA shall bear no responsibility for any inaccurate,
incorrect, offensive or misleading information contained herein.

The contents of this specific Transmission should not be construed as
representing the opinions or policies of Waterford Wedgwood, USA.

Waterford Wedgwood, USA shall not be liable for any loss or damage
arising as a result of any delay or omissions made in connection with
this Transmission.
**********************************************************************