Re: forwarding/sharing an odbc connection in a windows network

"quodlibet" <quodlibet*nospam*_at_ulyssis.org> wrote in message news:<1043072499.78945_at_seven.kulnet.kuleuven.ac.be>...
> I am using Oracle 8i ,
>
> I have a network with 5 client pc's (winXP) and a windows nt 4 server.
> The server has a connection to the rest of the world (including the oracle
> server),
> the clients don't . (<-this is the important part).
> I want to be able to use the tables in the oracle database from within
> ms access on the client pc's.
>
>
> I tried to make a odbc dsn with oracle on the server and then use the dsn
> on the clients .
> But the clients still try to make the connection with oracle themselves.
>
> Can anyone give me some pointers on how to solve this?

Here is an easy pointer... Install Oracle client on all client machines. It's quick to install and works like a charm.

If above is not doable then somewhat cryptic solution I could think of would be (Assuming you have Oracle client installed on NT server).

1. Create an Access database (TEST1) on NT server which connects to Oracle database using ODBC for Oracle driver. Create imported tables in TEST1 with data from Oracle database. Create a macro to refresh data periodically.
2. Create Access database (TEST2) on NT server which connects to TEST1 using MS Access driver. Create linked/imported tables in TEST2 with data from TEST1.
3. Have users connect to TEST2.

Downside.. No real time access to the data plus I am not sure you will be able to run update/inserts without writing some macro in TEST1.

Regards
/Rauf Sarwar Received on Tue Jan 21 2003 - 06:16:30 CET