473,325 Members | 2,608 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Minimum requirements for ODBC connectivity to Oracle database

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
3 9069
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
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
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Ton | last post by:
I have a question about connectivity between different databases. Oracle, DB2400 and SQL_server. It is easy to integrate application products that are running on different DB platforms? What...
2
by: GitarJake | last post by:
Hello all, I am trying to test an ODBC connection to an Oracle dbf using the ODBC Data Source Administrator. It's not working and I suspect I haven't configured Oracle correctly. Below is...
4
by: Andreas Lauffer | last post by:
Can anyone tell me advantages / disadvantages of DataDirect Server Wire ODBC-driver? Any experiences? What about redistribution? Andreas Lauffer, easySoft. GmbH, Germany
9
by: mcbill20 | last post by:
Hello all. I just installed Oracle 10g developer tools on a machine running XP Pro and Office XP. Before this I had just the Oracle 9 client installed. I the previous configuration, I was able to...
2
by: Mahesh.V | last post by:
Hi All I get the following error while connecting to the oracle database using ODBC. in my VB.NET application. Can any one help me out solving this problem server message (if any):...
8
by: Greg Strong | last post by:
Hello All, The short questions are 1 Do you know how to make DSN connection close in Access to Oracle 10g Express Edition? &/or 2 Do you know how to make a DSN-less pass-through query...
1
by: NMDevi | last post by:
I want to know about the connectivity of VB with Database. I am trying to connect the visual basic 6.0 with oracle-orahome92(SQL*Plus) using ODBC connectivity procedure.
1
by: NMDevi | last post by:
hello, I am working on VB 6.0 & oracle, i don't known how to give ODBC connectivity. Can any body help me in connecting VB with Database.
3
by: Alex | last post by:
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...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.