By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,007 Members | 1,248 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,007 IT Pros & Developers. It's quick & easy.

Information Integrator with Oracle

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Ian
st**********@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?

Nov 12 '05 #2

P: n/a
st**********@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
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.