Re: Fatal NI connect error 12203
- From: DA Morgan <damorgan@xxxxxxxxx>
- Date: Tue, 30 Oct 2007 08:46:59 -0700
nujcharee@xxxxxxxxxxxxxx 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@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.
- References:
- Fatal NI connect error 12203
- From: nujcharee
- Fatal NI connect error 12203
- Prev by Date: Re: CBO rows estimate way out in 2 table join - what to do?
- Next by Date: Re: OUI exits trying to install 10g
- Previous by thread: Fatal NI connect error 12203
- Next by thread: Re: Fatal NI connect error 12203
- Index(es):
Relevant Pages
|
