Re: Fatal NI connect error 12203
- From: Frank van Bortel <frank.van.bortel@xxxxxxxxx>
- Date: Wed, 31 Oct 2007 21:06:52 +0100
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
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...
.
- References:
- Fatal NI connect error 12203
- From: nujcharee
- Fatal NI connect error 12203
- Prev by Date: Re: slow migration path
- Next by Date: Re: Why Oracle creates two shared memory segments instead of one?
- Previous by thread: Re: Fatal NI connect error 12203
- Next by thread: Help: database can not be see from DBCA
- Index(es):
Relevant Pages
|
Loading
