ODP.Net Connection String

9 Jun 2006 4:11 AM

nitinvraj@gmail.com

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.

9 Jun 2006 7:01 AM

David Browne

<nitinv***@gmail.com> wrote in message

news:1149826262.527302.54280@j55g2000cwa.googlegroups.com...
>
> 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.
>

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