Re: Need help for MS Access connection to Oracle 7.3 on Unix

Frank,Bruce

I too used Intersolve for some time - however I found it increasingly hard to justify the Intersolve seat charges against Microsoft and Oracle free drivers.
In benchmark studies, Microsoft were considerably faster than Intersolve and Oracle were not far behind MS. MS have some functionality issues but are fine for most applications. I suggest you consider using MS 2.73 drivers.

regards

Matt

On Fri, 17 Apr 1998 12:35:41 -0400, Bruce Dodds <brucedodds_at_mediaone.net> wrote:

>Dear Frank -
>
>You will need an Oracle middleware product called SQL-Net, which runs on
>both the workstations and the server, in addition to ODBC drivers on
>each workstation.
>
>Two years ago I had good results using Intersolv ODBC drivers; Oracle's
>own native drivers weren't much good. That was an Access 2.0 <-> Win
>3.11 <-> NetWare3.12 <-> Oracle 7.3/AIX environment. It has since
>migrated to Win 95 with no problems.
>
>In your queries, avoid joining Access tables with Oracle tables if
>possible. The resulting "heterogeneous" joins are extremely slow.
>
>Get help from the Oracle people in your shop. Good luck.
>
>Bruce Dodds
>
>
>Frank Fang wrote:
>>
>> I am asked to connect Microsoft Access applications to the tables that
>> reside on Unix based Oracle 7.3 server through ODBC. I know ODBC on Windows
>> but have no idea about how to connect to Unix from Windows. Could anyone on
>> this group give me some idea to solve this problem. I would very appreciate
>> your help!
>>
>> Frank Fang from Indianapolis
Received on Sat Apr 18 1998 - 00:00:00 CDT