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.

Can you install Oracle on the server the clients all have access to? If so, you could potentially replicate the data from the real Oracle to this server, then use Access from the clients. If you want to change/ add data from Access, setting up this replication gets more complicated (though still possible). This assumes that you have the bandwidth/ hardware necessary to have a replicate instance on your server.

If you just want to view the data, you could set up a reporting tool (Crystal Reports, Brio, etc) on the server and view the reports on the client.

Is there a strong business reason that the clients can't be allowed to communicate with the database? If not, I'd really look to see whether you can relax this restriction.

Justin Cave

>
>
> 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?
>
>
> quodlibet
> \--
> I'm out of my mind, but feel free to leave a message
> \--
Received on Mon Jan 20 2003 - 23:43:05 CET