Connecting Tech Pros Worldwide Help | Site Map
 
 
LinkBack Thread Tools Search this Thread
  #1  
Old November 12th, 2005, 11:39 AM
stevenkblack@gmail.com
Guest
 
Posts: n/a
Default 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

  #2  
Old November 12th, 2005, 11:39 AM
Ian
Guest
 
Posts: n/a
Default Re: Information Integrator with Oracle

stevenkblack@gmail.com wrote:[color=blue]
> 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.[/color]

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?

  #3  
Old November 12th, 2005, 11:39 AM
Serge Rielau
Guest
 
Posts: n/a
Default Re: Information Integrator with Oracle

stevenkblack@gmail.com wrote:[color=blue]
> 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.[/color]
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
 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 205,164 network members.