SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
cant connect to oracle

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
cant connect to oracle
Author Message
pakya



Joined: 16 Feb 2005
Posts: 1

Post cant connect to oracle Reply with quote

i can connect to oracle using sql plus but when
i try to connect using SQL editor it gives error
ora-1215-TNS Could not resolve the connect
identifer specified

any idea?

Wed Feb 16, 2005 7:22 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7847

Post Re: cant connect to oracle Reply with quote

Your Oraclie client directory is not in the system search path, or you have multiple clients and old client is listed first. As a result either no TNSNAMES.ORA is found or wrong TNSNAMES.ORA file is found which does not contain the specified identifier.
Solution: make sure right Oracle client directory is added to the PATH environment variable.

: i can connect to oracle using sql plus but when
: i try to connect using SQL editor it gives error
: ora-1215-TNS Could not resolve the connect
: identifer specified

: any idea?

Wed Feb 16, 2005 10:34 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.