Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Fatal NI connect error 12203

Re: Fatal NI connect error 12203

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 30 Oct 2007 08:46:59 -0700
Message-ID: <1193759217.941834@bubbleator.drizzle.com>


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
>
> I dont have SQL Plus installed on my machine, is this relevant?
> Help please anyone?
> Much appreciated
>
> Peppe

Please understand that the version of Oracle you have is so old that when it was new dinosaurs walked the earth. In fact so old I can barely remember working with it. Any chance you could get a copy of Oracle to use that is supported on current operating systems and with current drivers?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Oct 30 2007 - 10:46:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US