The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!
Microsoft Oracle.Net data provider
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.
Asked:
-
2
1 Solution
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.
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
U should have Oracle client installed on every client system.