[Mono-bugs] [Bug 76408][Min] New - new OracleConnection("...") fails with DllNotFoundException: clntsh [incl. WORKAROUND]

[bugzilla-daemon at bugzilla.ximian.com]

Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.

Changed by jan.reitz at lanxess.com.

http://bugzilla.ximian.com/show_bug.cgi?id=76408

--- shadow/76408	2005-10-11 09:57:37.000000000 -0400
+++ shadow/76408.tmp.25715	2005-10-11 09:57:37.000000000 -0400
@@ -0,0 +1,75 @@
+Bug#: 76408
+Product: Mono: Class Libraries
+Version: 1.1
+OS: 
+OS Details: Windows XP SP2 with Mono 1.1.9.1
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Minor
+Component: Sys.Data
+AssignedTo: mono-bugs at ximian.com                            
+ReportedBy: jan.reitz at lanxess.com               
+QAContact: mono-bugs at ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+Summary: new OracleConnection("...") fails with DllNotFoundException: clntsh [incl. WORKAROUND]
+
+Please fill in this template when reporting a bug, unless you know what you
+are doing.
+Description of Problem:
+i try to open an oracle connection on my winXP machine and it fails in mono
+because of a missing "clntsh" (to my knowledge its the the oracle lib for
+unices)
+i have oracle 8.1.7 client package installed and it works with many other
+programs (programs that use OCI and not ODBC or something), and i have
+Oracle_home etc env-variables set. 
+in my PATH is "...C:\ORANT\ora81\bin...", this is where my oci.dll resides
+opening the connection with msft.net works as expected.
+
+Steps to reproduce the problem:
+1. fill strings "dsn user pass" with values for your oracle db
+2. con = new OracleConnection("DATA SOURCE="+dsn+";"+"USER
+ID="+user+";"+"PASSWORD="+pass+");
+3. 
+
+Actual Results:
+Unhandled Exception: System.DllNotFoundException: clntsh
+in (wrapper managed-to-native) OciNativeCalls:OCIEnvCreate
+(intptr&,System.Data.OracleClient.Oci.OciEnvironmentMode,intptr,intptr,intptr,intptr,int,intptr)
+in <0x0001f> System.Data.OracleClient.Oci.OciCalls:OCIEnvCreate
+(System.IntPtr envhpp, OciEnvironmentMode mode, IntPtr ctxp, IntPtr
+malocfp, IntPtr ralocfp, IntPtr mfreep, Int32 xt
+ramem_sz, IntPtr usrmempp)
+in <0x0003c> System.Data.OracleClient.Oci.OciEnvironmentHandle:.ctor
+(OciEnvironmentMode mode)
+in <0x0006b> System.Data.OracleClient.Oci.OciGlue:CreateConnection
+(OracleConnectionInfo conInfo)
+in <0x00042>
+System.Data.OracleClient.OracleConnectionPoolManager:CreateConnection
+(OracleConnectionInfo info)
+in <0x00038> System.Data.OracleClient.OracleConnectionPool:CreateConnection ()
+in <0x0010a> System.Data.OracleClient.OracleConnectionPool:GetConnection ()
+in <0x000ce> System.Data.OracleClient.OracleConnection:Open ()
+in (wrapper remoting-invoke-with-check)
+System.Data.OracleClient.OracleConnection:Open ()
+
+Expected Results:
+it should work :-D
+
+
+How often does this happen? 
+everytime
+
+Additional Information:
+
+i have found a workaround..... but its very ugly i think
+cd C:\ORANT\ora81\bin (My path to oracle)
+copy oci.dll clntsh.dll
+
+then it works like expected
+
+i have cygwin installed but i have stopped my x server, removed cygwin from
+PATH and renamed c:/cygwin to something else to not confuse mono that im on
+unix or something ....