Kbase P97538: Unable to do test connect or create package on AS/400 via ODBC Administrator
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/20/2005 |
|
Status: Unverified
FACT(s) (Environment):
ODBC DataServer
OpenEdge 10.x
OS/400 V5R1
OS/400 V5R2
SYMPTOM(s):
Unable to do test connect or create package via ODBC Administrator
Getting error "QSYS.NullID is undefined name" when creating ODBC package or doing test connect
using 4.2 DB2 Wire Protocol Drives
CAUSE:
The NULLID collection must be created on the AS/400. This library contains many packages such as DDODBCA, DDODBCB, DDODBC all of which are *SQLPKG type and PACKAGE attribute. The authority should also have *PUBLIC as *CHANGE. This library was not created.
FIX:
Create the NULLID collection.
CREATE COLLECTION "NULLID"
Verify the object authority for *public is *change
DSPOBJAUT OBJ(NULLID) OBJTYPE(*LIB)