Re: MS Access v2/ODBC v1.0/Oracle7
From: Elizabeth.Fitzpatrick <eliz_at_churchill.ColumbiaSC.NCR.COM>
Date: Wed, 27 Jul 1994 15:36:28 GMT
Message-ID: <CtLvCs.37_at_ncrcae.ColumbiaSC.NCR.COM>
Date: Wed, 27 Jul 1994 15:36:28 GMT
Message-ID: <CtLvCs.37_at_ncrcae.ColumbiaSC.NCR.COM>
In article <3130st$id9_at_yoda.Syntex.Com> lac_at_cowdreyl.syntex.com writes:
>
We were getting a similar problem that was corrected by setting
the CONFIG_FILES environment variable (in autoexec.bat) to point
to the oracle.ini file. For example: CONFIG_FILES=c:\windows\oracle.ini.
Hope it works for you,
-- Elizabeth Fitzpatrick (803) 939-6520 Process & Information Engineering elizabeth.fitzpatrick_at_ColumbiaSC.NCR.COM AT&T Global Information Solutions - PSSD ColumbiaReceived on Wed Jul 27 1994 - 17:36:28 CEST
>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
>------------------------------------------------------------------------