Re: Help: Designer/2000 connection problem

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Mon, 12 Apr 1999 13:45:16 +0200
Message-ID: <3711DCCB.755DF58E_at_vnl.nl>

That, and the fact, that your connect alias is des2000 as in your tnsnames.ora.
BTW, adding tns_admin to HKLM\Software\Oracle with a value of
%ORACLE_HOME%\net80\admin assures you only have to maintain
the network config files in the net80\admin diry, not network\admin as well.
Last, but not least, install SQL*Net Client off the 804 CD, make sure
you have the xxx02 (or was it 03?) version.

"R. Steven Brown" wrote:

It sounds like a problem I had with the same type of installation. I had to
update tnsnames.ora in network/admin AND net80/admin

Caobin Zhu <caobinz_at_flash.net> wrote in message
news:37114db6.18461976_at_news.flash.net...
>Hi, everyone,
> Please help me to make the connection from design/2000 2.1. to
>an oracle database.
>
> I am using oracle 8.0.4. After I installed design/2000 and
>made a database connection string (des2000 with repos as username and
>password for the database sid=d703) using net8 easy config, I can
>connect to the database from sql*plus 8. However I can not connect
>from designer/2000. Then I made another connection string (des2k)
>using sql net easy config for the same database (d703). I can not
>connect from designer or sql*plus 3.3 either. The error message is
>ORA-12505: TNS: listener could not resolve SID given in connect
>descriptor. I checked the services from NT server control panel. The
>database d703 shows status "started".
>
>I also checked the file tnsnames.ora under the network subdir. The
>following is part of that file:
>des2000.world =
>  (DESCRIPTION =
>    (ADDRESS_LIST =
>        (ADDRESS =
>          (COMMUNITY = tcp.world)
>          (PROTOCOL = TCP)
>          (Host = CHINESESTAR)
>          (Port = 1521)
>        )
>        (ADDRESS =
>          (COMMUNITY = tcp.world)
>          (PROTOCOL = TCP)
>          (Host = CHINESESTAR)
>          (Port = 1526)
>        )
>    )
>    (CONNECT_DATA = (SID = D703)
>    )
>  )
>
>What should I do to make this connection? First of all, I should use
>net8 easy config or sql net easy config? What is the trick?
>Any help would be greatly appreciated!
>Please help! TIA.
>You can e-mail the solution to me if you want to:
>caobin_at_flash.net
>

--
Frank van Bortel

Technical Consultant Oracle
V&L Informatica BV
-------------------------------------------------
Work                                Home
Postbus 545                         Hunzestraat 4
7500 AM Enschede                    7555 WB Hengelo
(31)53.434.1500                     (31)74.242.5046
  Received on Mon Apr 12 1999 - 13:45:16 CEST