By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,230 Members | 2,471 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,230 IT Pros & Developers. It's quick & easy.

Minimum requirements for ODBC connectivity to Oracle database

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Alex wrote:
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

you have to login to otn.oracle.com, go into the download section, the
clients are sometimes listed under the databases, other times they are
listed seperately. The login account is free if you don't have one.
Jul 19 '05 #2

P: n/a
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" <ph************@iliiearthilink.eionet> wrote in message
news:3F**************@iliiearthilink.eionet...
Alex wrote:
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

you have to login to otn.oracle.com, go into the download section, the
clients are sometimes listed under the databases, other times they are
listed seperately. The login account is free if you don't have one.

Jul 19 '05 #3

P: n/a
"Alex" <sh****@yahoo.com> wrote
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)?
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.
Is it necessary to install
SQL*Net or Net8 on the client machine?
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 :-)
If yes, where on Oracle Web site can
I find these products?
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.
Also, are they freeware?


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

--
Billy
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.