Re: Help: Designer/2000 connection problem

Thanks for the people who helped me to make the connect to oracle from designer/2000.

On Sun, 11 Apr 1999 22:40:13 -0600, "R. Steven Brown" <rstevenbrown_at_earthlink.net> 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
>>
>
>
Received on Sun Apr 18 1999 - 14:57:19 CEST