I have oracle XE 10g database on a windows server 2008. On the same server, I have a third-party application that needs to save data on the database. The application provides an interface whereby I need to give OLEDB connection details to the XE database. So I downloaded & installed ODAC1120320_x64 on the server and set the connection details as follows on the application:
Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=system;Password=XXXXXX
When I test the connection, it fails and in the log I get the following error:
The 'OraOLEDB.Oracle.1' provider is not registered on the local machine..
Pls suggest how to resolve this issue.
Issue solved. Previously installed drivers were causing the problem. Started with a clean windows server 2008 and then installed the ODAC. Connection working fine now.