[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