Re: How to useMS Access 97 to see Oracle 7 server?

Rob Williamson <robw_at_physics.umd.edu> wrote (in <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

Hello Rob,

1. you will need the appropriate version of the Client SQL*Net software on your PC. The Oracle databases that you can access from you machine depends on various factors. The quick and cheap way is to have a 'TNSNAMES.ORA' file in the <ORACLE HOME>\NETWORK\ADMIN directory.

This file will normally be provided by the DBA's of your system.

Another way is to use the Oracle Names server. I have no experience of this beast yet. It seems like a good idea for large sites.

To access the Oracle Database from the other products (MS Access etc.) then you need the appropriate ODBC drivers. I have not managed to get the Microsoft versions to work here yet, however, the Oracle or third-party once seem to work fine.

To set the ODBC driver up to connect to Oracle... 1) Select the correct Oracle Driver Version. 2) the 'connect string' to use is same as is in the 'TNSNAMES.ORA' file or the ones mentioned by the DBA's.

OK, where am i coming from

1. I have an Oracle Server on an OS/2 server (version 7,2).
2. i use TCP/IP as a network protocol.
3. i have 2 client PC's connecting to the server. The clients use Windows 95.
4. Each PC has a static IP address
5. I use MSAccess (ODBC) and Delphi (Direct Oracle Access) i to use the Oracle DB on the server.
6. I use Oracle Developer from one of the Client PC's against the Server DB.

graham     Received on Sat Feb 27 1999 - 09:09:14 CST