Solved

Microsoft Oracle.Net data provider

Posted on 2004-08-29
6
202 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
Comment Utility
HI Santosh,

U should have Oracle client installed on every client system.

0
 
LVL 14

Expert Comment

by:ptakja
Comment Utility
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
Comment Utility
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
Comment Utility
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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

771 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now