Cannot configure Oracle connector stage

farrider · Post by **farrider** » Tue Jul 24, 2012 4:43 am

Trying to set up an Oracle connector stage I get the following error when I press "Test": Error loading connector library ccora11g.dll. The specified module cannot be found.

I have 32-bit Oracle client 11gR2 installed and I run the Designer on Win7 64-bit. The Oracle client works fine, but it does not contain such a dll at all.

I've read this: http://www-01.ibm.com/support/docview.w ... wg21580377 and it doesn't help.

Thanks in advance for any ideas.

ArndW · Post by **ArndW** » Tue Jul 24, 2012 5:27 am

The module "ccora11g.dll" must be present and in the path on the DataStage server machine, not the client.
On my 8.7 version the dll is in the directory "D:\Program Files\IBM\InformationServer\Server\DSComponents\bin" on the server.

farrider · Post by **farrider** » Tue Jul 24, 2012 7:23 am

Thank you. I will speak to the administrator.