ODP.Net Connection String

  • Thread starter Thread starter nitinvraj
  • Start date Start date
N

nitinvraj

Hi all,

As I understand when using ODP.Net we have to provide in connection
string Data Source as the Net Service Name. Is there any way I can
connect without specifying the Data Source as I dont want to install
Oracle client manually and create Net Service on each client machine.

Thanks,
Nits.
 
Hi all,

As I understand when using ODP.Net we have to provide in connection
string Data Source as the Net Service Name. Is there any way I can
connect without specifying the Data Source as I dont want to install
Oracle client manually and create Net Service on each client machine.
Click to expand...


You must install the Oracle Client, but you don't need to create a
tnsnames.ora alias on each client. The 10g client lets you connect using
//hostname/servicename and skip creating a client alias.

David
 
Back
Top