Solved

Microsoft Oracle.Net data provider

Posted on 2004-08-29
6
242 Views
Last Modified: 2012-06-21
I'm using Microsoft Oracle.Net data provider to connect to my Oracle database through VB.Net.

I'm using the foll. conn. string

constrMain = "data source =serviceNameValue;User ID=userNameValue;Password=pwdNameValue

Is it necessary to have Oracle client installed on every client system wherever this product needs to be installed or there is any ohter way out wherein I can use MS Oracle .Net provider without having Oracle client installed on user system.

Thanks in advance.

Santosh Mhatre.

0
Comment
Question by:santosh_sbimf
  • 2
6 Comments
 
LVL 10

Accepted Solution

by:
123654789987 earned 25 total points
ID: 11929168
HI Santosh,

U should have Oracle client installed on every client system.

0
 
LVL 14

Expert Comment

by:ptakja
ID: 11931567
I believe the MS Oracle .Net Provider utilizes code/files from the Oracle Client in order to talk to the database.  There are many files that control access to Oracle databases don't exist without the client installed.
0
 
LVL 8

Expert Comment

by:wguerram
ID: 11932769
Why don't you use Oracle .NET Data provider

http://www.oracle.com/technology/tech/windows/odpnet/index.html

Using this driver, they don't mention you have to use the client installed.

I would be better to use them, since you will get best performance.
0
 
LVL 10

Expert Comment

by:123654789987
ID: 11940076
Your problem will be solved if u are using a 3-tier application. In this case if the business logic was separated from UI, then
u could have had the Oracle.Client installed on only one machine, since only one machine would execute database queries.

But, if U are having a 2-tier application then u have to install either Oracle client or the above mentioned driver in every client machine.



0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VB.NET 2008 - SQL Timeout 9 49
vb.net and creating a class 5 29
Convert Ctime to date time in textfile? 7 58
Vb.net threads keep increasing 2 48
Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

680 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question