Using DG4DRDA 11.2 Gives Error Odbc Db2 Wire Protocol Driver]Not Authorized To Access Database %S1. {Hy000,Nativeerr = 1243}
(Doc ID 1367450.1)
Last updated on MAY 11, 2022
Applies to:
Oracle Database Gateway for DRDA - Version 11.2.0.2 and laterInformation in this document applies to any platform.
Symptoms
Using Database Gateway for DRDA (DG4DRDA) 11.2.0.x running on a RHEL 5 x86_64 bit platform to connect to an AS/400 or iSeries DB2 database results in the following error -
[Oracle][ODBC DB2 Wire Protocol driver]Not authorized to access database %s1. {HY000,NativeErr = 1243}[Oracle][ODBC DB2 Wire Protocol driver]File not found '.odbc.ini'. {HY000,NativeErr = 1509}
A gateway debug trace shows the following output -
hgopoer, line 231: got native error 1243 and sqlstate HY000; message follows...
[Oracle][ODBC DB2 Wire Protocol driver]Not authorized to access database %s1. {HY000,NativeErr = 1243}[Oracle][ODBC DB2 Wire Protocol driver]File not found '.odbc.ini'. {HY000,NativeErr = 1509}
Exiting hgopoer, rc=0 at 2011/10/05-17:52:28
hgocont, line 2754: calling SqlDriverConnect got sqlstate HY000
Exiting hgocont, rc=28500 at 2011/10/05-17:52:28 with error ptr FILE:hgocont.c LINE:2774 FUNCTION:hgocont() ID:Something other than invalid authorization
Exiting hgolgon, rc=28500 at 2011/10/05-17:52:28 with error ptr FILE:hgolgon.c LINE:790 FUNCTION:hgolgon() ID:Calling hgocont
Entered hgoexit at 2011/10/05-17:52:28
[Oracle][ODBC DB2 Wire Protocol driver]Not authorized to access database %s1. {HY000,NativeErr = 1243}[Oracle][ODBC DB2 Wire Protocol driver]File not found '.odbc.ini'. {HY000,NativeErr = 1509}
Exiting hgopoer, rc=0 at 2011/10/05-17:52:28
hgocont, line 2754: calling SqlDriverConnect got sqlstate HY000
Exiting hgocont, rc=28500 at 2011/10/05-17:52:28 with error ptr FILE:hgocont.c LINE:2774 FUNCTION:hgocont() ID:Something other than invalid authorization
Exiting hgolgon, rc=28500 at 2011/10/05-17:52:28 with error ptr FILE:hgolgon.c LINE:790 FUNCTION:hgolgon() ID:Calling hgocont
Entered hgoexit at 2011/10/05-17:52:28
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |