Problem using ADO to connect to 8i

From: Christian Weyer <weyer_at_igd.fhg.de>
Date: Fri, 20 Aug 1999 16:20:04 +0200
Message-ID: <37BD6414.CED8BEC4@igd.fhg.de>

Hi all,

I have big problems in using the latest Oracle ODBC driver (8.01.05.00) when connecting my VB client to the database via ADO. When using the Microsoft ODBC driver for Oracle or the Microsoft OLEDB Provider for Oracle everything works fine and I can connect to the DB. But when issuing the Oracle driver I get an error! I do need the Oracle driver because currently it is the only way to retrun RECURSORs from stored procedures (this structure resembles the ADO recordset object).
If someone has more information or is interested I can also send my VB code.

The following is logged in sqlnet.log (and it is always the same connection string
in ADO - the same SQL/Net servicename):

Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\TEMP\Project1.exe)(HOST=NTSRV8)(USER=Administrator))))

  VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.1.5.0.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.5.0.0 -
Production
  Time: 20-AUG-99 14:17:30
  Tracing not turned on.
  Tns error struct:
    nr err code: 0
    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

Any more information and help is very appreciated.

Christian
--

 Christian Weyer                                   eYesoft

 Martinstraße 139                  Softwareentwicklung und
 64285 Darmstadt                                  Beratung

 christian.weyer_at_eyesoft.de   Tel.+ Fax: +49-(0)6151-62325
 http://www.eyesoft.de           Mobil: +49-(0)177-6111527


-----------------------------------------------------------

Verteilte Architekturen unter Windows NT / Windows 2000 + Schulung + Beratung + Entwurf + Implementierung +

Received on Fri Aug 20 1999 - 09:20:04 CDT