Re: Multiple ORACLE7 Connects

You can make a "startup" menu-like application which will ask for login details before proceeding. After logging in, this application can run each distinct application (using the Run() function) passing login details as arguments. The callees can read arguments with CommandParm() function. Your startup application should log the user into Oracle for verification and then logout. The callee should login again silently with the login details received as arguments.
Alternatively you can rewrite your applications and make them part of one (big I guess) so you can use the same sqlca object and dont have to login-logout-relogin as described above. Both ways, you can keep your passwords - and you should do so.

Hope this helps!

Keith Mallen <kmallen_at_onramp.ca> wrote in article <01bd76ee$2964ae40$eb59e1cc_at_default>...
> We have written several new ORACLE7 applications, using Powerbuilder 5.
> The users are getting tired of having to enter the same userid and
 password
> over and over again, once for each application. Has anyone found a way
> that a single logon can be done and used for all applications. NOTE: we
> don't want to eliminate passwords alltogether.
>
> Thanks
>
Received on Tue Jun 09 1998 - 00:00:00 CDT