The specified module could not be found.

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
denzilsyb
Participant
Posts: 186
Joined: Mon Sep 22, 2003 7:38 am
Location: South Africa
Contact:

The specified module could not be found.

Post by denzilsyb »

hallo!

Ray - ozzies won a tough match on saturday. well done to gregan and his men.

I get the following error when accessing db2 data (well, I try).

Code: Select all

ds_loadlibrary: Win32 error in LoadLibrary of dsdb2.dll - The specified module could not be found.
The set up is as follows: we connect via DS clients to a DS server. One of our developers can access the data using the server/uid/pwd that is set up in the ODBC of the server. The rest of us get the above error.

Firstly, what could be the problem? We are all connecting to the same server yet the developer gets to see the data and we do not - using the same method, even same job to view data.

thanks is advance
dnzl
"what the thinker thinks, the prover proves" - Robert Anton Wilson
hassers
Participant
Posts: 14
Joined: Thu Dec 11, 2003 11:34 am
Location: Chester, UK

COnnecting to DB2 via ODBC

Post by hassers »

I'd check that the user account allows multiple sessions / connections?
- but would expect a better error message.

Security on an IBM Mainframe - Aghhh - Joy on monday morning .
Thanks

Steve
mleroux
Participant
Posts: 81
Joined: Wed Jul 14, 2004 3:18 am
Location: Johannesburg, South Africa
Contact:

Post by mleroux »

Howzit Denzil

When you say only one developer can access the data, is it one developer out of the bunch or the first one that accesses it?

Is the required dsdb2.dll file in your client's /engine/bin directory?
Morney le Roux

There are only 10 kinds of people: Those who understand binary and those who don't.
denzilsyb
Participant
Posts: 186
Joined: Mon Sep 22, 2003 7:38 am
Location: South Africa
Contact:

Post by denzilsyb »

hi morne

we all have the dll required. i asked the developer to log in from my pc and test and no luck with the data.

Im getting unable to initialize plug in when trying to import db2 plugin metadata - think this could have anything to do with it? ive tried 3 times now to reregister the plugin (using start/programs..), all with the same error when trying to import mdata.

"unable to initialize.. " unable to initialize..." "unable to initialize..."

aargh!
dnzl
"what the thinker thinks, the prover proves" - Robert Anton Wilson
mleroux
Participant
Posts: 81
Joined: Wed Jul 14, 2004 3:18 am
Location: Johannesburg, South Africa
Contact:

Post by mleroux »

Did you use Manager (using menu Tools -> Register Plug-In...) to register the plug-in? It should be OK though if the plug-in was installed at initial DataStage installation.
Morney le Roux

There are only 10 kinds of people: Those who understand binary and those who don't.
denzilsyb
Participant
Posts: 186
Joined: Mon Sep 22, 2003 7:38 am
Location: South Africa
Contact:

Post by denzilsyb »

Hi Morney

Looking a little better - I have it working (almost) on my pc. i.e. if i import metadata for a table on db2 its working. now, when i want to view the data i get error messages that disappear as soon as i remove the derivation...

which i have just fixed by importing the metadata checking "import qualified table names"

and now for the server implementation :twisted:

thanks dude
dnzl
"what the thinker thinks, the prover proves" - Robert Anton Wilson
Post Reply