DB2 - Problembeschreibung
Problem IC65888 | Status: Geschlossen |
IBM OLE DB PROVIDER WILL NOT SHOW UP IN THE LIST OF AVAILABLE 'NATIVE OLE DB' DRIVERS IN DB2 RUN-TIME CLIENT FOR WINDOWS | |
Produkt: | |
DB2 CONNECT / DB2CONNCT / 970 - DB2 | |
Problembeschreibung: | |
On Windows 32-bit/64-bit server with DB2 V9.7 Runtime Client, IBM OLE DB Provider will not show up in the list of available 'native OLE DB' drivers for example within Microsoft SQL Server 2005/2008 and SQL Server Business Intelligence Development Studio | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Windows * **************************************************************** * PROBLEM DESCRIPTION: * * IBM OLE DB PROVIDER WILL NOT SHOW UP IN THE LIST OF * * AVAILABLE 'NATIVE OLEDB' DRIVERS ON DB2 RUN-TIME CLIENT FOR * * WINDOWS * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V9.7 FP 2 or higher * * * * OR * * * * Use Temporary Fix * **************************************************************** | |
Local-Fix: | |
Workaround is to register OLEDB manually using regsvr32, i.e, OLEDB provider self registration code is called when you call regsvr32 command. for 32bit RTCL, run C:\WINDOWS\system32\regsvr32 /s <DB2InstallationPath>\bin\ibmdadb2.dll for 64bit RTCL, run C:\windows\syswow64\regsvr32 /s <DB2InstallationPath>\bin\ibmdadb2.dll - to register a 32-bit dll C:\windows\system32\regsvr32 /s <DB2InstallationPath>\bin\ibmdadb264.dll - to register a 64-bit dll For example, if the product is installed in "C:\ProgramFiles\IBM" folder on a 32-bit Windows server, running below dll registration command resolves the problem C:\WINDOWS\system32\regsvr32 /s C:\Program Files\IBM\SQLLIB\BIN\ibmdadb2.dll For regsvr32 usage options, refer: http://support.microsoft.com/kb/249873 | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 V9.7 FP 2 | |
Workaround | |
Workaround is to register OLEDB manually using regsvr32, i.e, OLEDB provider self registration code is called when you call regsvr32 command. for 32bit RTCL, run C:\WINDOWS\system32\regsvr32 /s <DB2InstallationPath>\bin\ibmdadb2.dll for 64bit RTCL, run C:\windows\syswow64\regsvr32 /s <DB2InstallationPath>\bin\ibmdadb2.dll - to register a 32-bit dll C:\windows\system32\regsvr32 /s <DB2InstallationPath>\bin\ibmdadb264.dll - to register a 64-bit dll For example, if the product is installed in "C:\ProgramFiles\IBM" folder on a 32-bit Windows server, running below dll registration command resolves the problem C:\WINDOWS\system32\regsvr32 /s C:\Program Files\IBM\SQLLIB\BIN\ibmdadb2.dll For regsvr32 usage options, refer: http://support.microsoft.com/kb/249873 | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 27.01.2010 27.04.2010 19.08.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP2 | |
Problem behoben lt. FixList in der Version | |
9.7.0.2 |