ODBC for Personal Oracle 7

From: Gilles TRAN <tran_at_inapg.inra.fr>
Date: 1996/11/28
Message-ID: <329DEC44.3A49_at_inapg.inra.fr>#1/1


Hello
I just bought Personal Oracle 7 for Windows NT3.51 Workstation and tried to setup the OBDC driver to use Access or Excel as front-ends (on the same computer). I first discovered that the OBDC driver was only for 16-bit software (not usable with Access 7 for intance) but I still can't access the Oracle database from the 16-bit Access 2 or other 16-bit software. All I got is the following message (when trying to attach a table for instance) :

"ORA-03121 no interface driver connected - function not performed".

The TNSlistener service is started and Oracle is working fine. The connect string for the ODBC driver is "2:" (even tried "TNS:2").

There's probably some piece missing but I can't figure it out, even after reading the Oracle tips and hints about OBDC drivers. Anyone has an idea ? It must be pretty obvious since my configuration is (I think) basic.

Thanks in advance

Oracle version 7.2.2.4.0
SQL*NET Client 2.2.2.10A
SQL*NET Server 2.2.2.10A

Oracle OBDC Driver 1.11.0.5.0 and 1.11.1.5.0

Gilles Tran
Association Francaise de Zootechnie
French Feed Database Received on Thu Nov 28 1996 - 00:00:00 CET

Original text of this message