Re: Link Oracle 7.3 Unix into Access 97 Windows?

You will need:
- SQL*Net client installation on your laptop - SQL*Net server on your unix machine, including a working listener configution, to be able to connect to your database over TCP/IP or whatever protocol, with TNS
- Configure your laptop SQL*Net and TNSNAMES to connect to the server (you can verify this using tnsping aliasname, or tnsping80 aliasname) - install and configure ODBC on your laptop, using the alias you configured earlier.
You cannot directly connect to the database using only ODBC, you will also need SQL*NET. There might be an ODBC driver that comes prepacked with sqlnet, but I don't know that for sure.

Jeroen

"Frank A. Grahek" wrote:

> I have an oracle database that resides on a unix box and stores our
> Interactive Voice data. Oracle came pre-installed from Lucent and I don't
> have any experience with it. I would like to be able to link the oracle
> database tables into access 97 on my laptop running windows 2000. I have
> heard you can do this but I haven't had any experience with it. Someone
> helped me set up a listener file on the unix box. I seem to have the odbc
> driver on my laptop but when I try to link data in I get a "ORA-03121: no
> interface driver connected" error, Can someone help me?
>
> grahekf_at_sprynet.com
Received on Wed Mar 28 2001 - 23:35:13 CEST