My local client have informatica PC 9.1 with DataDirect ODBC 6 and informatica BDE 9.6.1 with DataDirect ODBC 7.1 installed and are able to import table from oracle 11g db via ODBC 6 driver before.
Last month db was migrate to Oracle 12c, 9.1 designer no longer ablt to import table from oracle db 12c any more. But my colleague are able to import via ODBC 7.1
The error on my client for import table via ODBC 7.1 is as follows:
Specified driver could not be loaded due to system error 125: The specified module could not be found. (DataDirect 7.1 Oracle Wire Protocol, C:\Informatica\9.6.1\clients\tools\ODBC7.1\dwora27.dll)
I checked the dll it does exist on the location. Also I checked the registry entry, it looks both setup and driver point to the same location. Does anyone have similar experience and how to check and resolve it?
This could be a possibility of file corruption if the file exists. Can you try copying the file from a working environment and check if that helps?