Re: Oracle Designer: Connect string

If you config your tnsnames.ora properly, you should not worry about
hostname, port id or even instance name. How do you connect to the
database via your other tools?
It should be something like this in sqlplus:

username/password@ABC

or in TOAD, what do you put in the filed 'Database'?

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.

Frank van Bortel wrote:
Jens Lenge schreef:
Frank van Bortel wrote:

vanbortel.blogspot.com - search for the Network Blues

Hmmm... that refers to SQL Plus and involves manual editing of config
files and/or environment variables.

Maybe I am just a little blind, but I did not find how the GUI-"connect
string" for Designer must be composed of host IP, port, and SID.

Could you please give a little example (such as "<host>:<port>:<sid>"
or something like that)?

Jens

And building some understanding of what is going on, actually.

Did you try host:port:sid?

--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

.

Relevant Pages