MS Access v2/ODBC v1.0/Oracle7

From: <lac_at_cowdreyl.syntex.com>
Date: Tue, 26 Jul 94 13:49:12 PDT
Message-ID: <3130st$id9_at_yoda.Syntex.Com>

I am getting:

[Microsoft][ODBC DLL] Driver's SQLSetConnectOption failed [#0]
[Oracle][ODBC Oracle Driver]Driver not capable. [#0]
[Oracle][ODBC Oracle Driver][Oracle OCI]ORA-06107: NETTCP: ORACLE network
server not found. [#6107]

whenever I try to attach an Oracle7 table to an Access v2 database. I have tried reinstalling ODBC v1.0 and Oracle's driver for Oracle7 Oracle7 ODBC Driver Version 1.1.0.0 (Level 1 Driver), but I still get this wonderful message. However, MS Query and the ODBC Test program by Oracle both work fine without any problems and return the expected results.

Does anyone have any ideas? Is MS Access v2 looking for a Level 2 Driver or have I missed something?      

If you have any ideas, please either reply to this message or send e-mail lac_at_cowdreyl.syntex.com.   

Thanks.

---

Lee Cowdrey (Oracle Specialist)
Medical Research Europe

Syntex Development Research
Grenfell House
13-35 Grenfell Road
Maidenhead
Berkshire
SL6 1ES
United Kingdom

Tel:       44-628-770990 (extension 3102)
Fax:       44-628-789524

E-Mail: lac_at_cowdreyl.syntex.com

---

Received on Tue Jul 26 1994 - 22:49:12 CEST