Skip to Main Content

Oracle Database Discussions

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!

Need help on Oracle Driver

453552Jul 5 2011 — edited Jul 5 2011
I am using Oracle 10g and I want to set up ODBC at Control Panel(Administrative Tools).

I have to driver in ODBC to setup New Data Source fro Oracle, that is
1. Oracle in OraClient11g_home1
2. Oracle in OraDB10g_home1

When in choose the Oracle in OraClient11g_home1 driver. The TNS Service Name did not list up.

But when i choose Oracle in OraDB10g_home1 driver , the TNS Service Name will list up.

Why it happend?


I need to used Oracle in OraClient11g_home1 driver because i need to used ODP.NET.


The tnsnames.ora for Oracle in OraClient11g_home1 are located at C:\app\Administrator\product\11.2.0\client_1\Network\Admin.

The tnsnames.ora for OraDB10g_home1 are located at C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN





All contains in tnsnames.ora are same
*******************************

ORCL1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = fakhrimini)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl1)
)
)


EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)


*********************************


Can someone help me on how to make The TNS Services Names list in Oracle in OraClient11g_home1 driver?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 2 2011
Added on Jul 5 2011
15 comments
1,385 views