home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC70744 Status: Geschlossen

DATA LINK PROPERTIES IN MICROSOFT EXCEL AND SQL SERVER MANGEMENT STUDIO
DOESNOT SHOW DB2 COPY NAME APPENDED TO DB2 OLE DB PROVID

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
IBM OLEDB Provider listing in "Data Link Provider" does not show 
DB2 copy names when multiple copies are installed. 
 
Repro steps 
open the excel 2007 
Go to menu 
Data -> Get External Data -> using wizard (3rd option) -> 
Other/Advanced drivers -> choose driver with copy name 
For excel 2003 the 
Data->import external data->Connect to new data 
source->Other/advanced 
 
Using sql server managment studio 
Connect to sql server using sql server mangement studio 
Go to linked server ->new linked server 
it will open linked server diaglog box which will list oledb 
providers. 
 
It lists OLE DB Provider(s) and that is where IBM OLEDB 
Providers are listed . Some of them might be displayed 
without having copyname appended 
 
This can happen if the installed DB2 copy is default and in that 
case the DB2 COPY name is not appended to OLEDB provider. 
the problem doesnot happen when installed DB2 copy is non 
default one where the actually copy name is appended. 
 
the excel/SQl server management studo reads the DB2 OLE DB 
provider from 
"HKEY_CLASSES_ROOT\CLSID\{IBMDADB2 guid}\OLE DB Provider" key
Problem-Zusammenfassung:
see problem abstract.
Local-Fix:
To get copy name for other IBM oledb providers which has not 
showing copy name appended in DB2 oledb provider list, do this 
process as workaround 
 
1)Using regedit go to 
HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstalledCopies 
2) Change the  named "Default" to some value like DB2 ( value 
other than installed DB2Copy names) 
3)Get the sqllib/bin folder path which correspond to db2copy 
which is not appended in oledb provider string in excel DSN 
dialog box. 
4) Run regsvr32 "DB2copypath/sqllib/bin/ibmdadb2.dll" from 
start->run 
5) Repeat step 3 and 4 for other DB2copies for which OLEDB 
provider copy name is not appended in excel DSN dialog box. 
6) Close the excel and reopen it and check if dsn dialog box is 
showing the copyname now 
7) Revert back the DB2 copy value changed in step 2 to original 
DB2 copy
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
24.08.2010
10.01.2011
10.01.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
9.1.0.7 FixList
9.5.0.7 FixList