Deploying Windows Application with ODP .NET

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I hope this is the right place for this, if not please move it.

I have developed a windows application which uses an Oracle database for
storage. In order to communicate with the DB, I am using the ODP .NET
provider from Oracle. This works well on my development platform, however
when I try to run the application on a client machine I run in to problems. I
have copied and pasted the error at the bottom of this message.

Some background information. I compiled the application in 'Release' mode. I
copied the entire folder over to the client, including the
Oracle.DataAccess.Client.DLL file.

Is there a step I have missed here, or does something need to be required on
the client computers in order for this to work?

Thanks for your help,

Tas

Error message:
---------------

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.DllNotFoundException: Unable to load DLL 'OraOps10w.dll': The
specified module could not be found. (Exception from HRESULT: 0x8007007E)
at Oracle.DataAccess.Client.OpsTrace.GetRegTraceInfo(UInt32& TrcLevel,
Int32& StmtCacheSize)
at Oracle.DataAccess.Client.OraTrace.GetRegistryTraceInfo()
at Oracle.DataAccess.Client.OracleConnection..ctor(String connectionString)
at Oracle.DataAccess.Client.OracleDataAdapter..ctor(String
selectCommandText, String selectConnectionString)
at HRTrainingApplication.ucEmployees..ctor() in D:\VS
Projects\HRTrainingApplication\HRTrainingApplication\ucEmployees.cs:line 29
at HRTrainingApplication.Form1.treeView1_AfterSelect(Object sender,
TreeViewEventArgs e) in D:\VS
Projects\HRTrainingApplication\HRTrainingApplication\Form1.cs:line 24
at System.Windows.Forms.TreeView.OnAfterSelect(TreeViewEventArgs e)
at System.Windows.Forms.TreeView.TvnSelected(NMTREEVIEW* nmtv)
at System.Windows.Forms.TreeView.WmNotify(Message& m)
at System.Windows.Forms.TreeView.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
IntPtr wparam, IntPtr lparam)
 
Tas said:
I hope this is the right place for this, if not please move it.

I have developed a windows application which uses an Oracle database
for storage. In order to communicate with the DB, I am using the ODP
.NET provider from Oracle. This works well on my development
platform, however when I try to run the application on a client
machine I run in to problems. I have copied and pasted the error at
the bottom of this message.

Some background information. I compiled the application in 'Release'
mode. I copied the entire folder over to the client, including the
Oracle.DataAccess.Client.DLL file.

Is there a step I have missed here, or does something need to be
required on the client computers in order for this to work?
Click to expand...

You have to install ODP.NET on every client machine. This is necessary
because the Oracle.DataAccess dlls use the oracle client beneath it to
communicate with Oracle.

FB
Thanks for your help,

Tas

Error message:
---------------

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.DllNotFoundException: Unable to load DLL 'OraOps10w.dll': The
specified module could not be found. (Exception from HRESULT:
0x8007007E) at
Oracle.DataAccess.Client.OpsTrace.GetRegTraceInfo(UInt32& TrcLevel,
Int32& StmtCacheSize) at
Oracle.DataAccess.Client.OraTrace.GetRegistryTraceInfo() at
Oracle.DataAccess.Client.OracleConnection..ctor(String
connectionString) at
Oracle.DataAccess.Client.OracleDataAdapter..ctor(String
selectCommandText, String selectConnectionString) at
HRTrainingApplication.ucEmployees..ctor() in D:\VS
Projects\HRTrainingApplication\HRTrainingApplication\ucEmployees.cs:li
ne 29 at HRTrainingApplication.Form1.treeView1_AfterSelect(Object
sender, TreeViewEventArgs e) in D:\VS
Projects\HRTrainingApplication\HRTrainingApplication\Form1.cs:line 24
at System.Windows.Forms.TreeView.OnAfterSelect(TreeViewEventArgs e)
at System.Windows.Forms.TreeView.TvnSelected(NMTREEVIEW* nmtv) at
System.Windows.Forms.TreeView.WmNotify(Message& m) at
System.Windows.Forms.TreeView.WndProc(Message& m) at
System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&
m) at
System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
IntPtr wparam, IntPtr lparam)
Click to expand...



--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------
 
Back
Top