Re: Oracle ODBC connection???

From: Michael Krolewski <mikkro_at_hbsi.com>
Date: 1997/12/16
Message-ID: <34977F6C.12E0_at_hbsi.com>#1/1


Lee Zeitz wrote:
>
> Can anyone provide me with a clue on how to setup my Oracle Workgroup
> Server 7.3.2.2.1 running on Windows NT 4.0 Workgroup to function as an
> ODBC server for windows 95 using the NetBeui tranport.
>
First off, there is no such thing as an ODBC server. ODBC is a connection
protocol. Within Oracle, ODBC is a layer above the base SQL*Net layer.

Install the SQLNet software onto the portable. Confirm that the portable can start and connect via SQL Plus application.

Get the ODBC drivers from an appropriate source. (Oracle !?) For MS Access
7.0 you need the 32 bit drivers, for MS Access 2.0 16 bit drivers.

Follow the installation instructions on the portable. Remember to run the
ODBC admin software.

Use the test program to confirm that you have a connection to Oracle via the ODBC drivers.

Test the same within MS Access -- use the link table command to associate
with the Oracle database.

> I am writing a program for a notebook computer which will get data from
> the server, and then go out into the field and use the data. At the end
> of the day, the machine will come back and update records on the
> server. I plan on doing this by using MS Access on the notebook
> computer and downloading the records through an ODBC connection. The
> only problem is that Oracle's documentation does not tell me anything
> about how to setup the machine as an ODBC server.
>
> Any ideas??
Received on Tue Dec 16 1997 - 00:00:00 CET

Original text of this message