Re: Fatal NI connect error 12203

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 31 Oct 2007 21:06:52 +0100
Message-ID: <fgan8o$jg5$1@news1.zwoll1.ov.home.nl>

nujcharee_at_googlemail.com wrote:
> Trying to use link tables via ODBC using Oracle driver within MS
> Access, I received the following error message
>
> 1. Within MS Access, ORA-12154: TNS: could not resolve service
> name.... Driver's SQLSetConnectAttr failed IM006 0
>
> 2. Errors within SQLnet.log
>
> Fatal NI connect error 12203, connecting to:
> (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)
> (ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)
> (ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:
> \Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE)(HOST=BTC300397)
> (USER=nh2952))))
>
> VERSION INFORMATION:
> TNS for 32-bit Windows: Version 8.0.6.0.0 - Production
> Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version
> 8.0.6.0.0 - Production
> Time: 29-OCT-07 15:52:17
> Tracing not turned on.
> Tns error struct:
> nr err code: 12203
> TNS-12203: TNS:unable to connect to destination
> ns main err code: 12560
> TNS-12560: TNS:protocol adapter error
> ns secondary err code: 0
> nt main err code: 530
> TNS-00530: Protocol adapter error
> nt secondary err code: 0
> nt OS err code: 0

In addition to what Ed says, this setup tries to:

- use oracle V8.0
- connect to an instance, called ORCL
- on the same machine, you start access from

 (which strikes me as odd - why use access   when you have a database?!?).

Back to you:

- do you have the Oracle databse software on this machine?
- did you create a database?
- did you call it ORCL?

If any of these questions is answered with 'No', get someone to install the Oracle 8.0 client software; the network stack is sufficient.
Get someone to configure SQL*Net, and retry...

And no - not having SQL*Plus does not matter - if you had it, I would have known you had the Oracle network stack installed, so, basically - it would have helped.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Wed Oct 31 2007 - 15:06:52 CDT