I have developed a VB application that uses Oracle 8i database for backend.
The database server is on the local network. From my development machine,
the application connects (via ODBC) to the database successfully. The
problem is that I want to install this application on several Windows 2000
client machines that do not have Oracle client installed (hence missing all
the ODBC connectivity support files/drivers). What is the minimum
requirements, in terms of support files, for ODBC connectivity to an Oracle
8i database (other than an Oracle ODBC driver)? Is it necessary to install
SQL*Net or Net8 on the client machine? If yes, where on Oracle Web site can
I find these products? I searched the site over and over, but I was unable
to find them. Also, are they freeware? Any help would be greatly
appreciated.

Thanks,

Alex

Alex wrote:
clients are sometimes listed under the databases, other times they are
listed seperately. The login account is free if you don't have one.

YES YOU NEED THE CLIENT SOFTWARE.

You also need to decide whether to develop using the MS Oracle ODBC driver
or the Oracle Oracle ODBC driver (not a misprint) .

To get the client download 8i Enterprise Ed from OTN; 8i client is an
install option from the CD image.




There are some notes on Metalink about packaging and response files ...

As for freeware NO it's NOT freeware; you need to check your server
licencing as to how many users can connect. Its free to download for
development. for example if you have production processor licence for
server you're OK otherwise you probably need to buy more client licences.

Speak to an Oracle sales rep.

"pheonix1t" <pheonix1t898oi (AT) iliiearthilink (DOT) eionet> wrote

"Alex" <sh2222 (AT) yahoo (DOT) com> wrote

Oracle client networking (e.g. SQL*Net, Net8, Net9 - be careful though
with Net8 and Net9 as there are problems using it to access old 7.x
databases).

TCP/IP.

Yes and no.

In most cases yes. There are however 3rd party solutions that provides
a "native Oracle OCI driver" that includes Oracle networking within
the driver. Thus no need for having to Oracle Net installed on the
client.

Either way, you (or the client) need to fork out money for the Oracle
client connectivity libraries. Though in Oracle's case, that I think
is usually addressed by the overall licensing which is purchased by
the client (I'm not exactly up to date, nor interested, in the
financial/purchasing issues :-)

Look at the DOWNLOADS button at www.oracle.com (it is on the right of
the title of the page). As another poster said, you will need to
register. Registration is however free.

No. You can download for evaluation purposes. You are *not* allowed to
distribute them as "freeware" with your application.

--
Billy