Re: Importing oracle database into MSAccess

> winston <student9_at_singnet.com.sg> writes:
> Presently, I have an Action remedy system that uses oracle database. I
> want to use MSAccess from a remote PC to access these databases in the
> server. I tried using the "create a link to external database"
> option in MSAccess and chose the "Oracle ODBC Driver for Rdb" as the
> driver.
>
> However, there is an error message "No data". Is there any other
> configuration or software installation I need to do on my PC or on the
> server.
>
> I have the following installed on my PC:
> SQL*net
> Oracle ODBC Driver for RDB
>
> Installed on server:
> Oracle RDB
> Oracle SQL/services
>>>>

Your biggest problem is that you have installed the ODBC driver for RDB and you haven't got an RDB database. RDB is NOT Oracle.

You need the ODBC driver for connecting to Oracle databases if you wish to connect to an Oracle database via ODBC. (Although you say you have "Oracle RDB" installed on the server, the fact remains that you're not running RDB.)

Michael Stowe
Constellation Engineering, Inc.
http://www.mcs.com/~stowe Received on Sun Mar 31 1996 - 00:00:00 CET