OraFAQ Forum: Windows » ODBC not reading TNS

Home » Infrastructure » Windows » ODBC not reading TNS_ADMIN (Oracle 10.2, Windows XP SP2)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

ODBC not reading TNS_ADMIN [message #351758]

Thu, 02 October 2008 19:55

SpJohnm
Messages: 3
Registered: October 2008
Location: Australia

Junior Member

My PC is on a large network and when I run ODBC (odbcad32.exe)
it uses a network tnsnames.ora.

I want ODBC to read the local tnsnames so I set up a TNS_ADMIN
variable pointing to my %ORACLE_HOME%\NETWORK\ADMIN directory.

I put the value for TNS_ADMIN in the Environment and in the registry.
All to no avail - ODBC still reads the network tnsnames.

How can I get it to read the local one?

Thanks,

SPJohnm

Report message to a moderator

Re: ODBC not reading TNS_ADMIN [message #351764 is a reply to message #351758]

Thu, 02 October 2008 22:17

ebrian
Messages: 2786
Registered: April 2006

Senior Member

Does your environment variables include %ORACLE_HOME% ? If not, did you try to include the full path to the tnsnames.ora ?

Report message to a moderator

Re: ODBC not reading TNS_ADMIN [message #351766 is a reply to message #351764]

Thu, 02 October 2008 23:10

SpJohnm
Messages: 3
Registered: October 2008
Location: Australia

Junior Member

Hi,

Yes, ORACLE_HOME is set (C:\Ora10g)
and TNS_ADMIN = C:\Ora10g\NETWORK\ADMIN

I was wondering - I am not the Administrator on my machine
but I have full administrator rights.

Regardless of this, would ODBC be using the Administrator
login which won't have the TNS_ADMIN variable set?

Thanks,

John

Report message to a moderator

Re: ODBC not reading TNS_ADMIN [message #351769 is a reply to message #351766]

Fri, 03 October 2008 00:21

ebrian
Messages: 2786
Registered: April 2006

Senior Member

You should be able to set TNS_ADMIN as a user environment variable using the account that has full administrator account. Specifying the TNS_ADMIN user environment variable as C:\ora10g\network\admin "should" work for you. This account does have read access to the directory, right?

Report message to a moderator

Re: ODBC not reading TNS_ADMIN [message #351785 is a reply to message #351758]

Fri, 03 October 2008 01:45

SpJohnm
Messages: 3
Registered: October 2008
Location: Australia

Junior Member

I can read the Administrators Documents and Settings but I
cannot log on as Administrator. I have "Administrator" rights
in that I can access most things an administrator can - except
the Admin login.

I don't have any trouble setting the TNS_ADMIN variable. I just
cannot get ODBC to use it when it reads the tnsnames.ora file.

[Updated on: Fri, 03 October 2008 01:47]

Report message to a moderator

Previous Topic:	Create table from EXCEL Table
Next Topic:	Help Required

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 24 22:07:14 CDT 2013

Total time taken to generate the page: 0.39083 seconds