Solved

Microsoft Oracle.Net data provider

Posted on 2004-08-29

Visual Basic.NET

1 solution

250 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.

Comment

Question by:santosh_sbimf

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

6 Comments

LVL 10

Accepted Solution

by:123654789987

123654789987 earned 25 total points

ID: 119291682004-08-30

HI Santosh,

U should have Oracle client installed on every client system.

LVL 14

Expert Comment

by:ptakja

ID: 119315672004-08-30

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.

LVL 8

Expert Comment

by:wguerram

ID: 119327692004-08-30

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.

LVL 10

Expert Comment

by:123654789987

ID: 119400762004-08-31

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.

Featured Post

Question has a verified solution.

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

VB .NET :: Using OleDB Connection to Pass Parameters Into a mdb Query

Article by: Bruce

If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…

Visual Basic.NET

Having fun with graphics: a VB.net GlassLabel control

Article by: Luis

A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …

Visual Basic.NET

Network monitoring: why having a policy is the best policy?

Video by: AdRem

Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

[Webinar] How Hackers Steal Your Credentials and Why Active Directory Must be Secure to Stop Them

Video by: Experts Exchange

Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…