> do i need to install the oracle client to connect to an oracle
> database ? i'm doing fairly basic queries to an oracle (9.2) database
> and will be rolling the app out to multiple windows desktops.
>
> will i need to install the oracle client on each windows desktop ? is
> there any advantage in connecting via odpnet (oracle.dataaccess)
> rather than using the built-in system.data.oracleclient.dll ?
>
> ideally i'd like to use the method that has the smallest footprint.
>
> many thanks in advance
>
> craig
>

> Yes, you need to install oracle client for the providers from both
> Microsoft and Oracle.
>
> If you use our product: SpeedyDBADO.NETProvider (the fastest and most
> secureADO.NETProvider over Wide Area Network).
>
> You can find our product at:http://www.speedydb.com
>
> Or you can find otherADO.NETProviders for Oracle at:http://www.sqlsummit.com/DataProv.htm
>
> Charles Zhanghttp://www.speedydb.com
> (SpeedyDBADO.NETProvider is the fastest, most secureADO.NETProvider
> over Wide Area Network)
>
> cra***@freenet.co.uk wrote:
> > do i need to install the oracle client to connect to an oracle
> > database ? i'm doing fairly basic queries to an oracle (9.2) database
> > and will be rolling the app out to multiple windows desktops.
>
> > will i need to install the oracle client on each windows desktop ? is
> > there any advantage in connecting via odpnet (oracle.dataaccess)
> > rather than using the built-in system.data.oracleclient.dll ?
>
> > ideally i'd like to use the method that has the smallest footprint.
>
> > many thanks in advance
>
> > craig

> On Apr 11, 1:55 pm, Charles Zhang <CharlesZh...@newsgroups.nospam>
> wrote:
>
>
>
>
>
> > Yes, you need to install oracle client for the providers from both
> > Microsoft and Oracle.
>
> > If you use our product: SpeedyDBADO.NETProvider (the fastest and most
> > secureADO.NETProvider over Wide Area Network).
>
> > You can find our product at:http://www.speedydb.com
>
> > Or you can find otherADO.NETProviders for Oracle at:http://www.sqlsummit.com/DataProv.htm
>
> > Charles Zhanghttp://www.speedydb.com
> > (SpeedyDBADO.NETProvider is the fastest, most secureADO.NETProvider
> > over Wide Area Network)
>
> > cra***@freenet.co.uk wrote:
> > > do i need to install the oracle client to connect to an oracle
> > > database ? i'm doing fairly basic queries to an oracle (9.2) database
> > > and will be rolling the app out to multiple windows desktops.
>
> > > will i need to install the oracle client on each windows desktop ? is
> > > there any advantage in connecting via odpnet (oracle.dataaccess)
> > > rather than using the built-in system.data.oracleclient.dll ?
>
> > > ideally i'd like to use the method that has the smallest footprint.
>
> > > many thanks in advance
>
> > > craig
>
> Hello Craig -
> Another option to consider would be to use an ADO.NET provider that is
> 100% managed.  This allows your application to interact directly with
> the database without the native database client libraries or any type
> of mid-tier server that is based on ODBC.  We have found that this
> approach provides superior run-time qualities (better performance,
> reliability and security since all of the application logic runs
> within the CLR), as well as significant development and deployment
> advantages (an ADO.NET provider that is 100% managed can be deployed
> along with your application using Click Once / no other components
> such as the native database client libraries need to be installed &
> maintained / version limitations relating to the native database
> clients are eliminated; it is even possible to run multiple
> applications on the same client using different versions of the
> ADO.NET provider).
>
> DataDirect provides 100% managed ADO.NET providers for Oracle, DB2,
> Sybase and SQL Server.  You can download the product here -http://www.datadirect.com/downloads/registration/connect_net/index.ssp
>
> Best of luck, Mark- Hide quoted text -
>
> - Show quoted text -