Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
Solved
Microsoft Oracle.Net data provider
Posted on 2004-08-29
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=
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.
I'm using the foll. conn. string
constrMain = "data source =serviceNameValue;User ID=userNameValue;Password=
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.
[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
-
2
6 Comments
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.
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.
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.
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.
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
1.0 - Introduction
Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET).
If ever there was a subject full of murkiness and bad decisions, it is this one! The first problem seems to be that people considering this task of converting…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"!
Step 1: Open a new google tab
Step 2: Go to the left hand upper corn…
Suggested Courses
Course of the Month10 days, 1 hour left to enroll
722 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.