Re: listeners/odbc/protocolAdaptError?

From: Tony Rees <antonie.rees_at_btinternet.com>
Date: Thu, 5 Jun 2003 12:30:20 +0100
Message-ID: <bbn9if$28e$1$8300dec7@news.demon.co.uk>

Here is a sample of a tnsnames.ora file. See what you can make of it for yourself rather than me spilling out thousands of words in this reply. Please note that you will have to configure your hosts file as well unless you use the IP address in the tnsnames. Note also that you need to get the port and sometimes the sid address correct especially if there are other oracle instances on your network

TNSNAMES.ORA:- TRAI =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.17.102)(PORT = 8526))     )
    (CONNECT_DATA =
      (SID = trai)
    )
  )

INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = stxnham-trees)(PORT = 1521))     )
    (CONNECT_DATA =

      (SERVER = SHARED)
      (SERVICE_NAME = TREES)
      (PRESENTATION = http://admin)

)
)

TREES =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = stxnham-trees)(PORT = 1521))     )
    (CONNECT_DATA =
      (SERVICE_NAME = TREES)
    )
  )

"dave" <dmusicman_at_sympatico.ca> wrote in message news:2olDa.5044$VS5.471596_at_news20.bellglobal.com...

> Hello newbie here... am trying to connect to Oracle Personal
> dition...( seemingly installed correctly..) through the Oracle 9.00.11.00
> odbc driver.. No Go.......
> Error messages ORA-12541 and 12560... I looked at docs could not
> interprit meanings.
> TNS ... no listener basically. In Oracle "Net Manager" I cant even
get
> the test to
> work correctly... I get TNS:Protocol Adaptor Error.. error in
fields
> or the server
> may not be ready for a connection. I have tried numerous variations on
> all the
> parameters that make sense to me (damn its hard sometimes being self
> tutoring :} )
> as well as using passwords other than the defaults (scott tiger..)
SQL*
> plus is working fine ..... and the MFC app that I wrote as a "querry tool"
> works fine with (I am ducking now lol) msaccess.... through odbc. Any
> suggestions help would be greatly appreciated!
> thx in adavance motivated frustrated newbie D.Moore
>
> Received on Thu Jun 05 2003 - 06:30:20 CDT