Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to useMS Access 97 to see Oracle 7 server?
Rob:
You need SQL*NET and a slew of registry entries on all client machines
accessing the Oracle Server. The easiest way is to intall the Oracle Client.
You will need to know the name of the server , the name of the Oracle
instance you want to connect to and the protocol your Oracle was set up to
listen on.
Next create an ODBC DSN for MS Access to use.
Rob Williamson wrote in message <36D6F846.8857CC0C_at_physics.umd.edu>...
>Does any one have any experience setting up a Win 95 /NT
>machine to talk to a remote ( Oracle Server running 7.3.3 on Dig Unix )
>We use SQL*NET V2 although I did not set it up and know little about it.
>
>Do I need to run this client software ( SQL*NET )on my Win 95 machine?
>And then set sometihing up in MS ACCESS? I just would like Query and
>Reporting
>ability.
>
>Thanks
>Rob
>
Received on Sat Feb 27 1999 - 08:06:02 CST