Home » Infrastructure » Windows » Conneting to remote database from windows
Conneting to remote database from windows [message #217907] Tue, 06 February 2007 01:13 Go to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
Can we connect to a remote database from windows without using @ , by setting any environment variable similar to TWO_TASK in Unix ?

Since I think ORACLE_SID can be used to connect to local databases only ...

Report message to a moderator

Re: Conneting to remote database from windows [message #218344 is a reply to message #217907] Wed, 07 February 2007 16:23 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You should be able to issue the following at the command prompt prior to making the connection:

C:\> set local=<tns_alias>

Report message to a moderator

Previous Topic: OraOLEDBrmc10.dll and memory
Next Topic: DST Patch on Laptop and PC
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 25 12:43:58 CDT 2022
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.