I've installed the trial version on our new machine, and imported all the settings from the old machine. However, none of my connections work. The old machine had Oracle 11.2 installed; the new one has Oracle 12.1 installed. I've tried creating a new connection like this:
I'm using the Oracle OLEDB provider, because the VC native provider requires that I set up a system DSN. I don't want to do that - I want all the connection settings stored within VC. It's giving me this error:
I've tried various things, such as using different names for the provider:
OraOLEDB.Oracle.1
OraOLEDB.Oracle.12
OraOLEDB.Oracle.1.2
OraOLEDB.Oracle.2
OraOLEDB.Oracle
I've also tried manually registering the DLL file:
regsvr32.exe OraOLEDB12.dll
It said it was successful, but VC still gives me the above error. Any thoughts on how to fix this?
Thanks.