After much Googling I have failed to make any resolution to the issue of 'OraOLEDB.Oracle' provider is not registered on the local machine
I am creating a c# program and am using OleDbConnection conn = new OleDbConnection("Provider=OraOLEDB.Oracle.1;User ID="+userid+";PASSWORD="+pwd+";Data Source="+dataview);
where userid, pwd, dataview are of course plugged in at runtime and something not to be shared here. Also tried "PLSQLRSet=1;Persist Security Info=False;" inside the connection string with no help.
I am creating this program on a windows 8 and also tried it on a Windows Server 2012. A previous tech also created a VB program with that string and never got it working on a 32-bit windows web server 2008.
I currently have oracle winx64_12102_client and ORACLE win64_11gR2_client on my two machines. The tsanames.ora file has only 1 dns ("DSPRO") set in it. I can test connection from ODBC 64-bit to the DNS and it connects. Even trying "tsnping dspro" in a CMD window and get an OK return. Even so I tried another solution to install the .dll file through another cmd command of "c:\Windows\system32\regsvr32.exe \oracle\product\11.2.0\client_1\bin\OraOLEDB11.dll" and it finishes successfully. Lastly I do have c:\oracle\product\11.2.0\client_1\bin set in my PATH
Any further suggestions would be welcome.