Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Problem: Connect to Oracle8i via ADO
I have test console application (written in VC++ 6) that uses ADO to connect
and open tables on an Oracle8i database. This test application works fine
as does SQL-plus to get to the database.
The problem is that I implement the above code in an extension DLL called by a third party app that runs as a W2K service. When the third party service application calls the ADO Open method - it fails and generates the following sqlnet.log:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=o racle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CON NECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\ThirdPartyApp\admserv5.exe)(HOST=MYMACH INENAME)(USER=Administrator))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.0.5.0.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.5.0.0 -
Production
Time: 18-OCT-01 13:37:26
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 assume it has to do with authentication, somehow. I have exhausted all the ideas from MSDN (i.e. configured sqlnet.ora for no authentication, checked MDAC components & registry settings - all with no success).
What does the third party service do differently than my test application for the same code ?
Thanks, John Received on Thu Oct 18 2001 - 13:00:14 CDT