Re: listeners/odbc/protocolAdaptError?

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Wed, 04 Jun 2003 19:50:34 +0200
Message-ID: <m9csdv40p9u5jbglbijr3jmteolinbpn9m@4ax.com>

On Wed, 4 Jun 2003 08:22:47 -0700, "dave" <dmusicman_at_sympatico.ca> wrote:

>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
>

The prerequisite is you did start the listener. The listener can be started using lsnrctl start Surely that is in the doco.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jun 04 2003 - 12:50:34 CDT