Download (Oracle Data Access Components (ODAC) for Windows) and install the Oracle provider (there are 32bit and 64bit versions), then use
The MSDAORA is only available for x86/32bit, there is no 64 bit driver, as Microsoft is no longer supporting MSDAORA and instead recommends you use the Oracle drivers.
No solution here but I know exactly what you are experiencing since I ran across this as well. I tried updating the driver but that did nothing to get rid of the error. I opened a case and after some troubleshooting was given a defect number of "185931" and that LANDESK is working on a fix for this. If you have support, open a case and reference the defect number so that, hopefully, it helps in getting the issue resolved quicker.
Hi Frank Wils,
thank you for the fast response, but where we have to configure this Provider? We can't find this option.
we also opened a case now and hope that they will fix this issue fast.
I finally found a solution :)!
I installed the 64-Bit client from Oracle and configured the system-DSN in the ODBC Administrator (64 Bit). After that I changed the typ of the DTS-importjob from ORACLE to ODBC (screenshot).
And thats it!
After that I got a new bug that we can't configure the changed DTS-importjobs because the "weiter"-Button (next-button) is not working anymore. But the import is working now.