Re: Developer 2000 Version 2.0 Connection Problem

  Hi Kirk,

  As far as I understand, Sql Plus 8.0 uses Oracle Net8, the TNSNAMES.Ora file should be put in directory ORACLE_HOME\net80\admin. ( the default directory in NT
is : c:\orant\net80\admin).

 But developer 2000 version2.0 uses SQL*Net 2.3, the network configuration file TNSNAMES.ORA
should be put in ORACLE_HOME\network\admin directory. Just copy tnsnames.ora and sqlnet.ora
from Oracle_Home\net80\admin to Oracle_Home\network\admin, Developer 2000 should work.

Hope this hopes.

Sean Zhang
mailto:sean_at_cnfei.com

Kirk W. Conrad <kwconrad_at_mdanderson.org> wrote in message news:7jm9h5$ekj$1_at_oac2.hsc.uth.tmc.edu...
> We just go Developer 2000 Version 2.0 to run with our Oracle 8 database.
I
> installed it on my NT workstation and ran Net8 Easy Config. I can get to
> the database with SQL Plus 8.0. However, I can't get any of the Developer
> 2000 components, like Report Builder, to get a connection. The message is
> REP-0501: Unable to connect to the specified database. ORA-12154:
> TNS:could not resolve service names.
>
> I had 2 tnsnames.ora files so I renamed one so that I would be dealing
only
> with a correct one. Is there any way to make sure Developer 2000 use this
> one? Also, we're not using domain names.
>
> Any suggestions and comments appreciated.
>
> Kirk
>
>
Received on Wed Jun 09 1999 - 21:11:44 CEST