Re: MS Access to Oracle

Goh Yan Pin (gohyp_at_solomon.technet.sg) wrote:
: 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

To correct the above misapprehension

There are ODBC products available that don't require the SQL-Net product.

VisionWare produce a product called SQL-Retiever 3.0. This is a set of level one (currently) ODBC drivers that support the following database systems

Oracle, Ingres, Informix and Interbase

on the following host systems

SunOS 4.1.3, SCO Unix, IBM AIX 3.x, HP-UX 9, Intel V.4 Unix and RISC Ultrix 4.x

Other database / host systems may be added in future.

The above product implements the communications between PC and host using a version of Sun's ONC RPC mechanism, and so does not require any networking product from the database vendor. Another benifit of this solution is that there is only one PC module to install, regardless of what mix of host databases you wish to connect to.

We also include a copy of the Novel TCP/IP stack to further reduce the cost of implementation. It will however also support all major PC TCP/IP stacks (including WinSock), as well as serial lines

Also provide is a module to convert between DDE and ODBC, so allowing Windows applications that are not yet ODBC aware to access remote databases.

For more details of the above please email sales_at_visionware.co.uk

I appologise for the (slightly) commercial nature of my post, but hope the above clarifies the actual situation.

Regards

Chuck Received on Fri Oct 15 1993 - 17:48:10 CET