Hi everyone.
I've installed Oracle Designer and Oracle database (Oracle Database
Express Edition 10g Release 2 (10.2) ). I would like to create ERD
diagram in Designer, but when try to execute it, the small window
appears with username, password and connect string. The username and
password I've already set. The problem is the connect string. When I was
reading an installation guide, during designer's installation there was
a field with service name (this is connection string - isn't?). But in
my case, I've got any service name field during the installation.

Can you help me to solve this problem?

Regards
Kuba

On Wed, 24 Oct 2007 12:48:36 +0200, qpon <jsolowiej (AT) gmail (DOT) com> wrote:

You should be able to use the same string or name normally used to
connect to the database.

B.'

Brian Tkatch pisze:
Sorry, but I don't get it.
During the connect to database I enter only username and password
without any string connection...

Regards
Kuba

On Wed, 24 Oct 2007 15:55:49 +0200, qpon <jsolowiej (AT) gmail (DOT) com> wrote:

Perhaps you can check your tnsnames.ora file for the connect name.

B.

"qpon" <jsolowiej (AT) gmail (DOT) com> wrote

Try with service name "XE".

Proet pisze:
Didn't work.
Error: ORA-12154

Regards
Kuba

Proet pisze:
I've found this in my tnsname.ora:

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = demon)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

It looks like my service name is "XE" but when I try to use it in login
process I get the same error: ORA-12154 :/

Any ideas?

Regards
Kuba

On Thu, 25 Oct 2007 09:07:37 +0200, qpon <jsolowiej (AT) gmail (DOT) com> wrote:

Try changing host to an FQDN. If it is Designer installed on the same
computer as the database, i wonder if localhost will work.

B.

Brian Tkatch pisze:
Localhost works fine.
I will try your suggestion.

Regards
K

qpon wrote:
one with XE (where you found this tnsnames.ora), and one for Designer.
The Designer OH also has a network\admin directory - copy the
XE home\network\admin\*.ora files over to Designer_Home\network\admin.

Or set tns_admin; more on
http://vanbortel.blogspot.com/2006/0...ork-blues.html

--
Regards,
Frank van Bortel

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