Kbase P25879: Failing to update the ODBC DataServer schema holder against
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/27/2003 |
|
Status: Unverified
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
FACT(s) (Environment):
ODBC DataServer
SYMPTOM(s):
Failing to update the ODBC DataServer schema holder against DB2/MVS with error 2104
Using DB2/MVS
More than one active procedure. Do not use default handle for GetInfo_buffer. (2104)
CAUSE:
Non existent SELECT permissions on the DB2 system tables.
FIX:
It is necessary to have the read permissions to all required system tables
in the DB2 database for the user account used to access the DB2 via the ODBC driver.
As specified in the "Progress DataServer for ODBC Guide",
chapter 3.5.1 "Establishing Permissions", one needs to have select privileges on
specific system tables or database catalog files in the ODBC data source to
create or update a schema image for the data source. For the DB2 it is necessary
to have select permission on the following system objects: systables,
syscolumns, sysindexes and syskeys.
On DB2/MVS, it is also needed to grant BINDADD permission and
CREATE IN COLLECTION NULLID permission to the host user. In addition to this,
one needs to have SELECT permission on the SYSIBM.SYSROUTINES table.