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

Hi Paranoia,

The MSDN document Oracle and ADO.NETsays:

"The .NET Framework Data Provider for Oracle provides access to an Oracle database using the Oracle Call Interface (OCI) as provided by Oracle Client software. The functionality of the data provider is designed to be similar to that of the .NET Framework data providers for SQL Server, OLE DB, and ODBC. "

The MSDN document System Requirements (Oracle)says:

"The .NET Framework Data Provider for Oracle requires Microsoft Data Access Components (MDAC) version 2.6 or later. MDAC 2.8 SP1 is recommended. You must also have Oracle 8i Release 3 (8.1.7) Client or later installed. "

Both the .NET Framework Data Provider for Oracleand Oracle Data Provider for .NET are data providers to access Oracle database. The former ships with.NET Framework and requires Oracle client version 8.1.7 or above. The latter is provided by Oracle company and requires Oracle client version 9.2 or later.

The Oracle Data Provider for .NET (ODP.NET) features optimized ADO.NET data access to the Oracle database. ODP.NET allows developers to take advantage of advanced Oracle database functionality, including Real Application Clusters, XML DB, and advanced security.

See the document Comparing the Microsoft .NET Framework 1.1 Data Provider for Oracle and the Oracle Data Provider for .NETfor more information about the difference.

Hope this helps.

Sincerely,
Linda Liu

System.Data.OracleClient talks with the Oracle client software. It can not replacethe Oracle client software. If Oracle allows redistributing the client software, publish it with your application.

---

MSMVP VC++

hi,

thanks for the response.

if this is the case, i was just wondering what reason is there to use System.Data.OracleClient over the ODP.Net provided by Oracle?

do you know of any links that supports your information... it's not that i don't trust you or anything but this will have a big impact on the client and i would want to be able to give them hard facts when they ask.

thanks.

Hi Paranoia,

The MSDN document Oracle and ADO.NETsays:

"The .NET Framework Data Provider for Oracle provides access to an Oracle database using the Oracle Call Interface (OCI) as provided by Oracle Client software. The functionality of the data provider is designed to be similar to that of the .NET Framework data providers for SQL Server, OLE DB, and ODBC. "

The MSDN document System Requirements (Oracle)says:

"The .NET Framework Data Provider for Oracle requires Microsoft Data Access Components (MDAC) version 2.6 or later. MDAC 2.8 SP1 is recommended. You must also have Oracle 8i Release 3 (8.1.7) Client or later installed. "

Both the .NET Framework Data Provider for Oracleand Oracle Data Provider for .NET are data providers to access Oracle database. The former ships with.NET Framework and requires Oracle client version 8.1.7 or above. The latter is provided by Oracle company and requires Oracle client version 9.2 or later.

The Oracle Data Provider for .NET (ODP.NET) features optimized ADO.NET data access to the Oracle database. ODP.NET allows developers to take advantage of advanced Oracle database functionality, including Real Application Clusters, XML DB, and advanced security.

See the document Comparing the Microsoft .NET Framework 1.1 Data Provider for Oracle and the Oracle Data Provider for .NETfor more information about the difference.

Hope this helps.

Sincerely,
Linda Liu

hi,

thank you very much for your help and for the information.

much appreciated.