Hi
I am trying to connect from .net windows application to oracle database. Do we have to install oracle client in every system where the application is running to connect to the remote oracle database..
Thanks in advance
views:
38answers:
4
+1
A:
You need to go and grab the Oracle Data Provider which will enable you to query Oracle databases using standard ADO.NET access patterns.
Matthew Abbott
2010-08-03 10:03:53
Oracle Data Provider is 287 mb..is there any other option to access oracle database with less download capacity
Ramesh
2010-08-03 10:51:48
While m_arnell's answer is technically correct, this one is better. Microsoft is dropping (has dropped) the Oracle System.Data.OracleClient support. ODP is the current suggested method of accessing Oracle databases.
Brad Bruce
2010-08-03 10:54:55
A:
You don't need to "install" it, but you do have to provide the appropriate DLLs with your assembly.
Hamid Nazari
2010-08-03 10:04:39
i am using System.data.oracleclient but it is throwing erroras oracle client required.(oracle database is in other system)
Ramesh
2010-08-03 10:14:54
A:
You will need to have either the full Oracle database client installed (or the instant client) on each workstation in order to communicate with an Oracle database server.
This is completely separate to the "OracleClient" ADO.net classes.
m_arnell
2010-08-03 10:47:53
A:
Check answers to question: Connection C# to Oracle for list of possible solutions for interfacing to Oracle.
zendar
2010-08-03 11:09:04