Skip to Main Content
Forums

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODAC/ODBC not picking up TNSNames.ORA entries

636752Mar 16 2013 — edited Mar 19 2013
Hi

I am using Windows Server 2008 R2 - 64 bit. I want to deploy an ASP.NET solution developed using ODAC

I installed win64_11gR2_client i.e a *64 bit Windows 11g R2 client* and ODAC software ODAC1120320_x64.msi on the SAME WINDOWS server using

The database is Oracle 11g on a 64bit Unix box.

Oracle Base: D:\Oracle

Oracle Home 1: D:\Oracle\product\11.2.0\client_1 ---> Oracle Client is installed here

Oracle Home 2: D:\Oracle\product\11.2.0\client_2 ---> ODAC ins installed here

I copied the TNSNames.ora file from Home1 to Network\Admin folder under Home 2.

When i tried to create the SYSTEM DSN, i find two entries in the

In the Windows ODBC to create New Data Source Select a driver Window: I saw two entries

Oracle in OraClient11g_Home1 ---> 11.02.00.01 ----> SQORA32.DLL
Oracle in OraClient11g_Home2 ---> 11.02.00.03 ----> SQORA32.DLL

Problem: When i try to create a DSN entry using the second entry ( Oracle in OraClient11g_Home2 ---> 11.02.00.03 ----> SQORA32.DLL ), the system does not show the entry in TNSNames.ora. This inspite of the fact that the TNSNames.ora file has been copied.

However when i use the first entry i.e ( OraClient11g_Home1 ---> 11.02.00.01 ----> SQORA32.DLL ), the TNSNames entry is getting populated with the entries properly. The connection also works fine when tested.

Regards

Govindarajan

Edited by: Govindarajan on Mar 16, 2013 8:48 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 16 2013
Added on Mar 16 2013
#odbc, #odp-net
2 comments
17,033 views