queries regarding connecting to oracle

[craigc]

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

 

[Charles Zhang]

Yes, you need to install oracle client for the providers from both
Microsoft and Oracle.

If you use our product: SpeedyDB ADO.NET Provider (the fastest and most
secure ADO.NET Provider over Wide Area Network).

You can find our product at: http://www.speedydb.com

Or you can find other ADO.NET Providers for Oracle at:
http://www.sqlsummit.com/DataProv.htm


Charles Zhang
http://www.speedydb.com
(SpeedyDB ADO.NET Provider is the fastest, most secure ADO.NET Provider
over Wide Area Network)

 

[mark.troester]

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)

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

 

[craigc]

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 -

many thanks for both your replies.

will take a look.

best regards

craig