Connection to Oracle Database from DotNet

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Prasad said:
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?
Click to expand...

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.
Click to expand...

www.connectionstrings.com
 
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
 
Back
Top