Hallo all,
I have a problem with ODP.NET managed driver. I have a simple VS2015 Solution with ODP.NET managed driver. In app.config i have given an user defined alias name which is not present in tnsnames.ora. I have renamed all my tnsnames.ora files so that the framework should not find them. It should only use my datasource in my app.config. But when i run this i get the oracle error message TNS Name cannot be resolved. I checked in process monitor, the application has tried to open the tnsnames.ora files in network/admin but it cannot read them (as i have renamed them, files don't exist). I tried the same solution from my colleague's machine and it works fine for her. We have checked the process monitor in her machine and it says,
12:01:13,5976214 FindLastState.vshost.exe 9172 QueryOpen .....\FindLastState\bin\Debug\tnsnames.ora NAME NOT FOUND
12:01:13,5977021 FindLastState.vshost.exe 9172 CreateFile ......\product\11.2.0\client_1\Network\Admin\tnsnames.ora NAME NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
12:01:13,5978072 FindLastState.vshost.exe 9172 CreateFile C:\Program Files (x86)\Oracle Developer Tools for VS2015\network\admin\tnsnames.ora NAME NOT FOUND Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a
I get the same entries in process monitor but it doesnot work. Can anyone help me in this?
Thanks in advance,
AGana