SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Not able to connect to oracle - Help me

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Not able to connect to oracle - Help me
Author Message
GSREDDY



Joined: 29 Apr 2007
Posts: 1

Post Not able to connect to oracle - Help me Reply with quote
Hi,

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production

what all the input i have to give in the following screen



i am getting the following message when i click on "Connect" button



and immediately followed by the following message




User Name : TEAM
DBName : FAST

kindly help me

-: GSReddy :-
Sun Apr 29, 2007 3:45 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
Looks like you have multiple Oracle clients and Oracle homes defined on your computer and an old Oracle client version is sitting first in the system search path. To make SQL Assistant use the correct Oracle client, on the connect dialog click the button with 2 "greater sign" symbols and in the additional options pick the correct Oracle home.

A better solution is to fix your Oracle client configuration and uninstall the old client or fix the PATH variable and Oracle registry settings and make it point to the new client. With correct client settings SQL Assistant can determine where your SQL*Plus is connected to without asking any questions and displaying unnecessary connections dialogs.
Sun Apr 29, 2007 12:03 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant 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.