RE: SQLRPGLE - Remotedata(RDB) connection error.

Krunal,

I think this is one of those issues that gets bigger each time you look at it... First of all, understand that RDB directory entries come in two flavors: SNA and TCP/IP. Authority is managed differently within these two transports. You do not specify what type of host you are connecting to, but in general, the remote DB must be an IBM host. You cannot normally register a Windows Sequel Server as a remote DB, since DRDA is foreign to that product.

Now, in your embedded SQL, in order to access a remote DB, you must use the CONNECT TO statement. This statement accepts userid and password, so you *could* simply hard-code those values into your application (not ideal)...... A middle ground might be to store these credentials in a dataarea or userspace object, and ensure that this storage object can only be accessed via adopted authority....

C/Exec SQL
C+ CONNECT TO REMOTEDB USER :g_UserId USING :g_Password
C/End-Exec

Eric DeLong


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of krunal Asodiya
Sent: Wednesday, July 30, 2008 5:34 AM
To: RPG400-L@xxxxxxxxxxxx
Subject: SQLRPGLE - Remotedata(RDB) connection error.


Hi,



I want to connect a remote database , by SQLRPGLE program.



That , I can connect & able to access remote database by creating
RDB database by WRKRDBDIRE command,



& access that by : connect to 'RDB name' syntax in SQLRPGLE
program.



But when ever I call the program , it's trying to connect by the
userprofile which called the program .



I want to called the program by predefined user profile , & I don't
want to mention the userid & password in a program because of
security reason.



So , what parameter I need to set in WRKRDBDIRE command during creating
a RDB database & What parameter I should pass during a CRTSQLRPGI
command,


While creating a object and SQLPKG on remote system.



Thanks and Regards,

Krunal