[Mono-list] Can't connect to Oracle with Mono 0.29 on WinXP

Uppenborn, Jason Jason.Uppenborn@atcoitek.com
Wed, 14 Jan 2004 17:28:31 -0700


Hi,

As you can see from the transcript below, I'm trying to connect to
Oracle.

Problem 1: I get runtime errors about System.Data.OracleClient.dll being
not found if it doesn't exist in the same directory as my executable --
meaning I had to copy it from C:\Program Files\Mono-0.29\lib to
wherever. Is this bugzilla material?

Problem 2: Once System.Data.OracleClient can be found, I get the
exception shown. Any suggestions for getting around this exception or
finding out more about it? (I don't have class sources to go looking
through.)

Thanks,
Jason=20

----- snip -----
M:\MONO\SOURCE>type try.cs
using System;
using System.Data.OracleClient;

public class Try {
    public static void Main( string[] args ) {
        OracleConnection dbConn;
        try {
            // connect to database
            dbConn =3D new OracleConnection(
                "Data Source=3Ddgdgis;"
                + "User Id=3Duser;"
                + "Password=3Dpasswd;" );
            dbConn.Open();
            dbConn.Close();
        } catch( Exception e ) {
            Console.WriteLine( e.ToString() );
        }
        dbConn =3D null;
    } // main()
} // class Try

M:\MONO\SOURCE>mcs /r:System /r:System.Data.OracleClient Try.cs

M:\MONO\SOURCE>try
System.Security.SecurityException:
System.Security.Permissions.SecurityPermissio
n
   at
System.Data.OracleClient.Oci.OciEnvironmentHandle..ctor(OciEnvironmentMo
de
 mode)
   at
System.Data.OracleClient.Oci.OciGlue.CreateConnection(OracleConnectionIn
fo
 conInfo)
   at System.Data.OracleClient.OracleConnection.Open()
   at Try.Main(String[] args)

Unhandled Exception: System.Security.SecurityException:
System.Security.Permissi
ons.SecurityPermission
   at System.Data.OracleClient.Oci.OciHandle.FreeHandle()
   at System.Data.OracleClient.Oci.OciHandle.Dispose(Boolean disposing)
   at System.Data.OracleClient.Oci.OciHandle.Finalize()

The state of the failed permission was:
<IPermission class=3D"System.Security.Permissions.SecurityPermission,
mscorlib, Ve
rsion=3D1.0.3300.0, Culture=3Dneutral, =
PublicKeyToken=3Db77a5c561934e089"
             version=3D"1"
             Flags=3D"UnmanagedCode"/>
----- snip -----

Is this a packaging bug? Does