|
Problem IC65768
|
Status: Closed |
-7778 ERROR WHEN ATTEMP THE TABLE LINK OPERATION FROM MS ACCESS USING FILE DSN BY DATA SERVER DRIVER PACKAGE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
The customer installed the Data Server Driver Package V95 FP4.
When attemp the table link operation from MS Access using file
data source, it fails in SYSTEM RESERVED ERROR (-7778). It can
get table list successfully when use the user data source or
system data source.
CLI trace shows the following error at the connect attempt..
SQLDriverConnectW( hDbc=0:1, hwnd=208:654,
szConnStrIn="DRIVER={IBM DB2 ODBC DRIVER -
IBMDBCL1};UID=Administrator;PROTOCOL=TCPIP;HOSTNAME=192.168.107.
162;PORT=50000;DATABASE=sample;FILEDSN=C:\Program
Files\Common Files\ODBC\Data Sources\Psample.dsn;",
cbConnStrIn=193, szConnStrOut=&058690d0, cbConnStrOutMax=513,
pcbConnStrOut=&0013c72c, fDriverCompletion=SQL_DRIVER_COMPLETE )
---> Time elapsed - +1.930000E-004 seconds
( Connection Dialog Message="Dialog Box Displayed", PWD Length=0
)
( Connection Dialog Message="A system error has occurred loading
db2clir.dll", Msg Number=2, Msg Text="WARNING! Could not
retrieve message text" )
( Connection Dialog Message="A system error occurred making a
system call to DialogBoxParam()", Msg Number=2, Msg
Text="WARNING! Could not retrieve message text" )
In the DSDriver ALL_LANG package, db2clir.dll and db2odbcr.dll
only in "\msg\en_US" folder. The other language folder does not
contain these two dll's. For DS Driver package all language
should have those dll's because DS Driver supports all locale.
Because of lacking db2clir.dll, the dialog box for password
prompt can not be called succsessfully and results in -7778
error later. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* non en_US language user *
****************************************************************
* PROBLEM DESCRIPTION: *
* The customer installed the Data Server Driver Package V95 *
* FP4. *
* When attempts the table link operation from MS Access using *
* file *
* data source, it fails in SYSTEM RESERVED ERROR (-7778). It *
* can *
* get table list successfully when use the user data source or *
* *
* system data source. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V97FP2 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
In the DSDriver ALL_LANG package, db2clir.dll and db2odbcr.dll
only in "\msg\en_US" folder. The other language folder does
not
contain these two dll's. For DS Driver package all language
should have those dll's because DS Driver supports all locale.
Because of lacking db2clir.dll, the dialog box for password
prompt can not be called succsessfully and results in -7778
error later. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 21.01.2010
10.05.2011
10.05.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
