Re: Help: Designer/2000 connection problem

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
>
Received on Mon Apr 12 1999 - 06:40:13 CEST