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

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 Fri Apr 17 1998 - 00:00:00 CDT