ODBC for Personal Oracle 7
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
