application using oracle database

Jim H

We have applications that must connect to oracle databases. Is there a way
to connect using .NET that does not require installation of the Oracle
client on each PC?

I'm pretty sure java apps do not require the Oracle client. I'm hoping .NET
has some way of doing this as well.

If not, does anyone know of a way to incorporate the oracle client install
with a .NET application install? I guess I'm looking ofr some kind of merge
module that can be used to setup the oracle client during our app install.
Oracle clients are usually a pain for users to configure.

Thanks,
Jim

Nov 15 '05 #1

Subscribe Reply

2101

David Browne

"Jim H" <no****@jimsacc ount.com> wrote in message
news:uk******** ******@TK2MSFTN GP10.phx.gbl...

We have applications that must connect to oracle databases. Is there a way to connect using .NET that does not require installation of the Oracle
client on each PC?

I'm pretty sure java apps do not require the Oracle client. I'm hoping ..NET has some way of doing this as well.
For Java there is a Type 4 (pure java) JDBC driver, called the JDBC Thin
driver from Oracle.
For .NET the only "Type 4" Oracle driver is from Data Direct, and it's very
expensive and therefore useless and little used.

If not, does anyone know of a way to incorporate the oracle client install
with a .NET application install? I guess I'm looking ofr some kind of merge module that can be used to setup the oracle client during our app install.
Oracle clients are usually a pain for users to configure.

Get ODP.NET, Oracle's data provider (otn.oracle.com ). It has an installer
(not an MSI, but an the Oracle Universal Installer), and will install both
the Oracle Client and the ODP.NET data provider. In addition you can try to
automate the install with a response file, and then launch it from your
installer. I've never done it, but it should be possible.

ODP.NET also supports some great features that the MS provider does not,
like Array Binding and PL/SQL Tables and BLOB's.

David

Nov 15 '05 #2

Carlos J. Quintero

I have not used it, but the only .Net Data Provider in the market that does
not require the Oracle client (OCI layer, etc.) is the one from
http://www.datadirecttechnologies.com It uses a TCP/IP connection with the
wire protocol directly, like the thin JDBC drivers.

All the remaining are built on top of the OCI layer.

HTH,

Carlos Quintero

"Jim H" <no****@jimsacc ount.com> escribió en el mensaje
news:uk******** ******@TK2MSFTN GP10.phx.gbl...

We have applications that must connect to oracle databases. Is there a way to connect using .NET that does not require installation of the Oracle
client on each PC?

I'm pretty sure java apps do not require the Oracle client. I'm hoping ..NET has some way of doing this as well.

If not, does anyone know of a way to incorporate the oracle client install
with a .NET application install? I guess I'm looking ofr some kind of merge module that can be used to setup the oracle client during our app install.
Oracle clients are usually a pain for users to configure.

Thanks,
Jim

Nov 15 '05 #3

Similar topics

4857

Load Balancing in Oracle 9i Forms Application

by: yagish | last post by:

Hi Techies, Am really new with the Oracle 9i Forms and am searching for a way to perform Load Balancing in Oracle 9i Forms Application. Its not a J2EE application, so cannot go the OC4J way. I need Load Balancing at 2 levels - 1) Load Balancing of the Forms Server 2) Load Balancing of the Database

Oracle Database

2424

Application crash on IBM AIX 5.2

by: Thanvir | last post by:

We have an application that runs under Linux, solaris. The Application was developed in C++ under linux, it supports both Oracle and Informix database. For database connectivity in oracle it uses OTL (Oracle template library) and for informix it uses ESQL In all the platforms we use GNU C/C++ compiler for building the executable( Version >= 3.3.2)

C / C++

2140

application design problem

by: Saso Zagoranski | last post by:

hi, this is not actually a C# problem but since this is the only newsgroup I follow I decided to post my question here (please tell me where to post this next time if you think this post shouldn't be here). I have two design questions: 1. what is the correct (or best) way to include database queries into the code if you plan on

C# / C Sharp

1866

Questions on application design

by: Matthew Hood | last post by:

My company has expressed a desire to convert an existing MS Access application to a full VB.NET application. My experience is with VB6 so I want to ask a few questions and get some input on the best way to handle the following design: Situation: We want to allow our customers to install with one of the following options: 1. Use an Access MDB file as the data backend. 2. Use a SQL Server backend. (Either MS SQL, or MySQL) 3. Use an...

Visual Basic .NET

1790

What technologies should I use for my application manager?

by: MrBlueSky | last post by:

Hello! I've just finished working on my first Python app (a Tkinter-based program that displays the content of our application log files in graphical format). It was a great experience that's had a very positive response from my colleagues. So I'd like to try something different for my second Python application. It's a simple server that can launch and monitor the state of our program, to help our software developers. In my mind I...

Python

1966

Upgrading Access 97 application to dotNet

by: kavsak | last post by:

Hi. Not sure that this is the right place to ask but here goes. I have an application based on access97 and VB6 which I need to upgrade. It has to handle up to 20 concurrent users on a Win2k network ( to be upgraded to XP next year) which has no connection to the outside world, but normally there are no more than 2. It has approximately 150 tables with complicated validation rules and a large amount of calculation. I want to rewrite it...

Visual Basic .NET

2228

OT Supporting an application

by: salad | last post by:

I have an application written in MS-Access. It is a complete application that manages the day-to-day operations of a business. The program is nearly ready to be used in other customer sites. I am wondering if any of you have advice on supporting an application. Since it has never had any outside exposure, what I don't want is to make a bunch of sales and not be able to support the issues that arise. I believe as kinks are worked out...

Microsoft Access / VBA

1543

Looking for a generic DB-maintenance application

by: jimenezkrause | last post by:

Hello, I administrate a large number of Oracle databases for my company. Some DBs are easily structured and the staff responsible for keeping them updated are able to use an Oracle client (SQirreL, PLSQL/ Developer, or even MS Access as a client) to directly access Oracle and update their tables (without messing around with integrity etc). Other DBs are too complex in their structure or the staff responsible

PHP

2047

DataBase is not Connected through Application

by: Vikrant Pendurkar | last post by:

When i tried to access my application its gives me below error. Microsoft OLE DB Provider for Oracle error '80004005' Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed. Note:- Database is on another Machine and We install Oracle...

Oracle Database

9721

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9600

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10373

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10374

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9195

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6880

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5547

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

3859

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

3011

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General