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 OCTOBER 14, 2011

Applies to:

Oracle Database Gateway for DRDA - Version: 11.2.0.2 and later   [Release: 11.2 and later ]
Information 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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms