[RESOLVED] System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

[adshocker]

hi all,

i was under the impression that using the System.Data.OracleClient namespace will allow me to deploy my application without having the client machine install any OracleClient software besides the .Net Framework 2.0 which if i'm not mistaken, contains the System.Data.OracleClient.dll.

but after creating a WinForm application and then publishing it thru ClickOnce , i found myself getting this error when running the application on the client machine.

is this a normal behavior or did i do something wrong in the process?

thanks

[adshocker]

does anyone have any information regarding this?

[gep13]

Hey,

Does this help you out:

http://www.dotnetjunkies.com/WebLog/rtgurskevik/archive/2005/01/19/45958.aspx

Gary

[adshocker]

hi,

thanks for the info.

unfortunately the article does not apply to my current situation. mine works when the application is run on the server. the problem occurs when it is run on some other machine.

thanks.

[GaryMazzone]

The Oracle client software still needs to be installed on the client computer to allow connection to the Oracle database. The database user the SQL*Net which is the Oracle conectivity layer for Oracle database. The System.Data.OracleClient dll does not provied this this function.

[gep13]

Hey Gary,

Good to know, I wasn't quite sure if that was the case or not.

Thinking about it, I guess it makes sense, the times that I have used the OracleClient, or rather the ODP.Net, the connection string has always used a name from the TNSNAMES.ORA file, so it stands to reason that the Oracle Client has to be installed in order to provide this functionality.

Thanks for the clarification.

Gary

[adshocker]

hi,

thanks for the info.

this must be off-topic but is there a way to have the oracleclient included when deploying applications using ClickOnce?

[gep13]

Hey,

Which installer package are you using?

You should be able to include the Oracle Client in your application package and then execute the necessary installation steps in a Custom Installer. Either that, or check to make sure that the Oracle Client is installed (i.e. check the registry) before installing your application and if it isn't there, prompt the user to install it, and exit your installation.

Gary

[adshocker]

thanks