Re: Correct ODBC driver

Paul Brewer (paulb_at_pbrewer.demon.co.uk) wrote:
: In article <55fs21$e5q_at_news1.gte.net>, Bill Barnard
: <wbarnard_at_pechan.com> writes
: >What is the correct version of the Oracle ODBC driver if I want to use Access
: >2.0 to connect to Oracle Workgroup server on a Windows 95 machine? I'm
: >running SQL*Net 2.3.
: >
: >Bill Barnard
: >wbarnard_at_pechan.com
: I'd recommend you use 32bit SQL*Net _and_ a 32bit ODBC driver.
: We haven't yet tried Oracle's 32bit ODBC driver, but we have tried
: Intersolv and OpenLink with your configuration. Both work fine.
:
: Paul Brewer

I don't think you can use Access 2.0 (16 bit) with a 32 bit ODBC driver and 32 bit SQL*Net (2.3 doesn't come in a 16 bit version anymore afaik). It is no problem, however, to use 16 bit SQL*net and a 16 bit ODBC driver on a 32 bit platform like NT or Win95.
Make sure you use all 16 bit components when using Access version 2.0.

dave

-- 
David-Michael Lincke
Research Assistant
Institute for Information Management IWI-HSG, University of St. Gallen
EMail:	David-Michael.Lincke_at_iwi.unisg.ch, dlincke_at_bandon.unisg.ch
URL:	http://www-iwi.unisg.ch/about/team/dal.html