Connection to Oracle Database from DotNet

[Guest]

Hi,
I have to connect to Oracle database which is on different machine from
the application server.To connect to oracle db from DotNet , do I need to
install oracle client?.Also please provide me the connection format I have to
use as I am new to oracle.

Thanks
Prasad

 

[Miha Markic [MVP C#]]

Hi,
I have to connect to Oracle database which is on different machine from
the application server.To connect to oracle db from DotNet , do I need to
install oracle client?

Yes, unless you use a 3rd party provider that doesn't need oracle client -
see a bunch of threads below for the similar question.

..Also please provide me the connection format I have to

use as I am new to oracle.

www.connectionstrings.com

 

[Cor Ligthert [MVP]]

Depends,

If you have used OleDB you can use an OleDB connectionstring, if you have
used SQLClient, you have to change it to the OracleClient (standard in
2003).

Cor