Re: MS Access to Oracle

Rob Peters (peters_at_bml4380.cpg.cdc.com) wrote:

: I have several questions regarding the use of MS Access in a client/server
: environment talking to Oracle
 

: First, the environment is a PC running Access, and a Oracle database on a UNIX
: box. The network is TCP/IP.
 

: My questions are:
 

: 1. Will this work with Access version 1.1?

Yes it would, we got it working here.

: 2. Is SQL#Net required on the client, server or both?

SQL*Net is required on both Clieht and Server. You have to use the windows version of SQL*Net, not the DOS version.

: 3. If SQL#Net is not required, will ODBC do the job by itself?

See above.

: 4. If ODBC can run without SQL#Net, what does it talk to on the
: server -- directly to Oracle or what?
In addition to SQL*Net, you will need a TCP/IP software on PC, SQL*Net supports products like PC/TCP, PC/NFS, Wollongong's TCP, Novell LAN Workplace etc.
: Thanks in advance

welcome.

: Rob
: rpeters_at_cdc.com
Received on Mon Oct 11 1993 - 10:16:12 CET