ODP.NET installed but now I think there might be two oracle homes? cannot connect anyway....
Posted on 2011-03-16
I was trying to install ODP.NET there, and that went ok. It installed to E:\oracle\product\10.2.0\client_1... But, the thing is I already have an oracle home under E:\oracle\ora92
So, I can connect OK using the ODACHome1 using TOAD and I can connect to the original home ORAHome92 ok. However, when I try it through code I get an error 'ORA-12154: TNS:could not resolve the connect identifier specified'.
I think this is probably because the default home is ORAHome92 and probably I need to set it to ODACHome1. Or, somehow I need to specify that the ODP.NET code should use ODACHome1. Well, I'm just guessing there really. What should I do to fix this? (I'm using VS 2005; VB.NET)