SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 04:39 AM
| ||||
| ||||
 Information Integrator with Oracle I just installed Information Integrator on my machine Windows XP db2 8.2.1. I want to connect to Oracle 9i. The closest thing I saw when trying to create the wrapper was Oracle8. It says the Library name is db2net8.dll but the error that comes up when I try to create it is "The specified library "db2net8U.dll" could not be loaded. SQLSTATE=42724" I found the db2net8U.dll in the f:\ibm\sqllib\bin directory so there is no reason that it shouldn't find it. My question is why does the wizard say the library is db2net8.dll and the error message looking for db2net8U.dll. Any help would be great. Steven      |
|
02-27-2008, 04:40 AM
| |||
| |||
| Re: Information Integrator with Oracle stevenkblack@gmail.com wrote: > I just installed Information Integrator on my machine Windows XP db2 > 8.2.1. I want to connect to Oracle 9i. The closest thing I saw when > trying to create the wrapper was Oracle8. It says the Library name is > db2net8.dll but the error that comes up when I try to create it is "The > specified library "db2net8U.dll" could not be loaded. > SQLSTATE=42724" > I found the db2net8U.dll in the f:\ibm\sqllib\bin directory so there is > no reason that it shouldn't find it. My question is why does the > wizard say the library is db2net8.dll and the error message looking for > db2net8U.dll. 1) You probably need the relational wrappers installed (this is a separate install from the base II product install) 2) Do you have the Oracle client software installed on your machine? |
|
02-27-2008, 04:40 AM
| ||||
| ||||
| Re: Information Integrator with Oracle stevenkblack@gmail.com wrote: > I just installed Information Integrator on my machine Windows XP db2 > 8.2.1. I want to connect to Oracle 9i. The closest thing I saw when > trying to create the wrapper was Oracle8. It says the Library name is > db2net8.dll but the error that comes up when I try to create it is "The > specified library "db2net8U.dll" could not be loaded. > SQLSTATE=42724" > I found the db2net8U.dll in the f:\ibm\sqllib\bin directory so there is > no reason that it shouldn't find it. My question is why does the > wizard say the library is db2net8.dll and the error message looking for > db2net8U.dll. Comments from "backstage": The db2net8.dll is the TOP library and is used as a hook to load the db2net8F.dll and db2net8U.dll libraries which contain all the code necessary for the Net8 wrapper. When user issues create wrapper we will load the db2net8.dll and the db2net8U.dll sequentially. The problem you are seeing is usually caused by a bad or unstable environment. Please make sure the DB2 fixpack level you are using matches the II fixpack level and make sure you reboot after installing these and the Oracle client just incase some environment variables and or registry variables aren't loaded correctly. If the problem persist please clear out the db2dj.ini file and update dbm cfg setting diaglevel to '1' and restart your instance, after you recreate the problem you should see more diagnostic info regarding the error in the db2dj.ini. Hope any of that makes sense :-) Serge -- Serge Rielau DB2 SQL Compiler Development IBM Toronto Lab |
Linear Mode
