I've managed to get ODP.NET working on my local machine, I can connect to the server and run queries on it etc so it's fine. I wanted to publish the code on the server and run the website but it didn't work. First I think there was a data provider error so I installed ODP.NET 10.2.020 on the server assuming that was the issue, but not I'm getting another error:
Oracle.DataAccess.Client.OracleException: ORA-12154: TNS:could not resolve the connect identifier specified
So, the server was running oracle before i did any install and the oracle home was D:\OracleClient\Install and the tns file resided under D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN. So, ODP.NET creates a new home under D:\oracle\product\10.2.0\client_1\NETWORK\ADMIN and I don't know if this causes a problem or not.
Does anyone know what is likely the issue here?