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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] +ReportedBy: [EMAIL PROTECTED] +QAContact: [EMAIL PROTECTED] +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 .... _______________________________________________ mono-bugs maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-bugs
