Re: Fatal NI connect error 12203

On Oct 30, 5:04 am, nujcha..._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

Aside from the fact that you are using a version of Oracle that hasn't been supported in this millennium, did you look up what a ORA-12154 indicates?

Not having SQL*Plus installed, per se, is not an issue, but it does indicate that you probably don't have an Oracle client installation at all, and that *is* a fundamental requirement.

Which version of Windows?
Which ODBC driver?
Is your database on the same machine as Access? What does your sqlnet.ora and tnsnames.ora file (on the Access machine) look like? Received on Tue Oct 30 2007 - 15:22:23 CDT