| Autoconnect from REXX script [message #99322] |
Tue, 13 May 2003 13:41  |
Martin Stoddard
Messages: 2
Registered: May 2003
|
Junior Member |
|
|
Getting ORA-01017: invalid username/password; logon denied attempting to connect to remote database via REXX script after 8.1.5.X to 8.1.7.4 upgrade. ALL other methods (interactive SQL, batch SQL, clist, etc) have no trouble autoconnecting to the same remote DB.
Has anyone had success autoconnecting to a remote DB with a REXX script in V8.1.7.4?
|
|
|
|
| Re: Autoconnect from REXX script [message #99323 is a reply to message #99322] |
Tue, 13 May 2003 15:16  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
If you get the "invalid username/password" error you have already successfully interacted with "a database". Check the following:
1) Ensure that you've contacted the correct database:
"ALLOC DD(ORA@dbname) DUMMY"
2) Ensure that you've specified the correct userid and password.
Best regards.
Frank
|
|
|
|
| Re: Autoconnect from REXX script [message #99325 is a reply to message #99323] |
Wed, 14 May 2003 13:02 |
Martin Stoddard
Messages: 2
Registered: May 2003
|
Junior Member |
|
|
Thanks for your reply Frank. After further testing, we've gotten autoconnect to work running REXX under JES. Speaking with the OS/390 SysAdmin, it seems her script is running from OPSMVS under Master -not- JES. Perhaps it doesn't provide current user information where JES does and in turn where Oracle expects to find it.
Regards,
- Martin
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
