DB2 - Problembeschreibung
Problem IC65768 | Status: Geschlossen |
-7778 ERROR WHEN ATTEMP THE TABLE LINK OPERATION FROM MS ACCESS USING FILE DSN BY DATA SERVER DRIVER PACKAGE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Lösung | |
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 | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 21.01.2010 10.05.2011 10.05.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP2 | |
Problem behoben lt. FixList in der Version | |
9.7.0.2 |