niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » Oracle
Oracle Designer: Connect string
Post new topic   Reply to topic Page 2 of 2 [16 Posts] View previous topic :: View next topic
Goto page:  Previous  1, 2
Author Message
Robbert van der Hoorn
*nix forums beginner


Joined: 29 Jun 2006
Posts: 16

PostPosted: Tue Jul 18, 2006 8:55 am    Post subject: Re: Oracle Designer: Connect string Reply with quote
"Jens Lenge" <Spampot@gmx.net> wrote in message
news:e9h2me$sft$03$1@news.t-online.com...
Quote:
akkha1234@gmail.com> wrote:

How do you connect to the
database via your other tools?

With Oracle SQL Developer, I just enter the host IP, port number, and SID
(and username/password, of course). It can then connect successfully.

But I guess SQL Developer does not refer to tnsnames.ora, while Designer
probably does.

Then stick the ABC or the database field as the connect string. Then
you are good.
If you get an error, this means your tnsnames.ora is not correct. This
would be a different issue.

I suspect you are right and my tnsnames.ora is not properly configured. I
was only using Oracle SQL Developer before I installed Designer (as part
of
the suite). I will check this next week when I'm back at work again.

Jens


If you're using more than one Oracle product, they may be installed in
different Oracle home directories.
You have two ways of solving tnsnames problems:

1) Find a working product, and copy the tnsnames.ora from its home directory
to the other home,or
2) set an (system) environment variable TNS_ADMIN pointing to the directory
of the working product, hence all other products will use this directory
too; usally it's something like c:\[oracle_home_name]\network\admin


Robbert
Back to top
Google
Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 2 of 2 [16 Posts] Goto page:  Previous  1, 2
View previous topic :: View next topic
The time now is Mon Dec 01, 2008 9:32 pm | All times are GMT
navigation Forum index » Databases » Oracle
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts Move Oracle 10g database to another location Selt Server 0 Fri Jul 21, 2006 2:14 pm
No new posts Oracle runtime Spitfire Server 0 Fri Jul 21, 2006 1:18 pm
No new posts FAQ 4.32 How do I strip blank space from the beginning/en... PerlFAQ Server Perl 0 Fri Jul 21, 2006 1:03 pm
No new posts Oracle Text Score Computation jatinder.1975@gmail.com Server 0 Fri Jul 21, 2006 1:00 pm
No new posts Connect to remote MySQL server Martin PHP 2 Fri Jul 21, 2006 8:20 am

Business Credit Card | Magic The Gathering Cards | Personal Loans | Credit Cards | 0 Credit Cards
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group

[ Time: 0.2304s ][ Queries: 16 (0.1667s) ][ GZIP on - Debug on ]