Date: Mon, 12 Apr 1999 02:05:08 GMT
Message-ID: <37114db6.18461976_at_news.flash.net>
[Quoted] Hi, everyone,
[Quoted] 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 - 04:05:08 CEST