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 -> Fatal NI connect error 12203

Fatal NI connect error 12203

From: <nujcharee_at_googlemail.com>
Date: Tue, 30 Oct 2007 03:04:51 -0700
Message-ID: <1193738691.412274.179410@19g2000hsx.googlegroups.com>


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 Received on Tue Oct 30 2007 - 05:04:51 CDT

Original text of this message

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