[Mono-devel-list] Exception using ASP.NET (XSP) and OleDb cla ss

[Gomez Aragoneses, Andres]

Thanks for your comments.

Look at my reply to Simon: it seems you're right, no lib-gda on Windows (is
this planned for future?, should we submit a bug report?).

But I have tried with OracleClient and I have a similar problem: another
exception.

System.DllNotFoundException: oci
in <0x00050> (wrapper managed-to-native) OciNativeCalls:OCIEnvCreate
(intptr&,System.Data.OracleClient.Oci.OciEnvironmentMode,intptr,intptr,intpt
r,intptr,int,intptr)
in <0x00020> System.Data.OracleClient.Oci.OciCalls:OCIEnvCreate
(intptr&,System.Data.OracleClient.Oci.OciEnvironmentMode,intptr,intptr,intpt
r,intptr,int,intptr)
in <0x0005a> System.Data.OracleClient.Oci.OciEnvironmentHandle:.ctor
(System.Data.OracleClient.Oci.OciEnvironmentMode)
in <0x0003c> System.Data.OracleClient.Oci.OciGlue:CreateConnection
(System.Data.OracleClient.OracleConnectionInfo)
in <0x0002b> System.Data.OracleClient.OracleConnection:Open ()
in <0x0004c> (wrapper remoting-invoke-with-check)
System.Data.OracleClient.OracleConnection:Open ()
in <0x00080> ConexionDB:prueba ()
in <0x000c3> Inventario:Calculate (object,System.EventArgs)
in <0x00066> (wrapper delegate-invoke)
System.MulticastDelegate:invoke_void_object_EventArgs
(object,System.EventArgs)
in <0x00092> System.Web.UI.WebControls.Button:OnClick (System.EventArgs)
in <0x0004f>
System.Web.UI.WebControls.Button:System.Web.UI.IPostBackEventHandler.RaisePo
stBackEvent (string)
in <0x00016> System.Web.UI.Page:RaisePostBackEvent
(System.Web.UI.IPostBackEventHandler,string)
in <0x0003e> System.Web.UI.Page:RaisePostBackEvents ()
in <0x00266> System.Web.UI.Page:InternalProcessRequest ()
in <0x000ad> System.Web.UI.Page:ProcessRequest (System.Web.HttpContext)
in <0x002c7> ExecuteHandlerState:Execute ()
in <0x0007b> StateMachine:ExecuteState
(System.Web.HttpApplication/IStateHandler,bool&)


And the thing is that I have used the *same* example as the one shown in
http://go-mono.com/oracle.html, so I don't understand it. I think I have
found again someone with the same problem as mine
(http://bugzilla.ximian.com/show_bug.cgi?id=57392) but I don't know why this
bug was closed as "resolved-notabug".

Anyone could clarify this? Thanks.

	Regards,

		Andrew


-----Mensaje original-----
De: Rafael Teixeira [mailto:monoman at gmail.com]
Enviado el: martes, 14 de septiembre de 2004 20:37
Para: Gomez Aragoneses, Andres
CC: mono-devel-list at lists.ximian.com; sibain at tendotzero.com
Asunto: Re: [Mono-devel-list] Exception using ASP.NET (XSP) and OleDb
class


I'm not sure that libgda is available in Windows, so that you could
follow Simon's advice.
Also, to connect to Oracle databases I think it is better to use the
specific provider not OLEDB/odbc.
Mono has an implementation of System.Data.OracleClient.dll (see:
http://www.go-mono.com/oracle.html), but again I'm not sure if it
binds correctly to the Windows' version of the Oracle Client dlls.

Hope it helps,

On Tue, 14 Sep 2004 15:52:07 +0200, Gomez Aragoneses, Andres
<agomez at wke.es> wrote:
> Hello guys.
> 
> I am developing an ASP.NET application and I have problems connecting to
the
> database. No compilation errors but I catch this exception:
> 
> System.DllNotFoundException: gda-2 in <0x00050> (wrapper
managed-to-native)
> System.Data.OleDb.libgda:gda_init (string,string,int,string[]) in
<0x0003e>
> System.Data.OleDb.OleDbConnection:.ctor () in <0x0000a>
> System.Data.OleDb.OleDbConnection:.ctor (string) in <0x00053> (wrapper
> remoting-invoke-with-check) System.Data.OleDb.OleDbConnection:.ctor
(string)
> in <0x00065> ConexionDB:prueba ()
> 
> My block of code is:
> 
> public class ConexionDB {
> 
>    const string sCon = "DSN=cronos_geac_oracle;PASSWORD=xxxxx;UID=user;";
> 
>    public string prueba () {
> 
>      OleDbConnection oCon;
> 
>      try {
>        oCon = new OleDbConnection(this.sCon);
>      }
>      catch (Exception e) {
>        return e+"";
>      }
> 
>    }
> }
> 
> The thing is that I have already found one person that has had my problem,
> but it seems no one replied his message (thread formed by only one
message):
> 
> http://www.mail-archive.com/mono-list@lists.ximian.com/msg09588.html
> 
> The unique difference, I think, is that I am on Windows XP and he is on
> Linux. Version of Mono: 1.0.1.
> 
> Anyone could comment anything about this? Thanks very much in advance.
> 
> --
>        Regards,
> 
>                Andrew
> _______________________________________________
> Mono-devel-list mailing list
> Mono-devel-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-devel-list
> 



-- 
Rafael "Monoman" Teixeira
---------------------------------------
Cognition is not a representation of an objectively existing world
but is a bringing forth of a world in the process of living.
-- Fritjof Capra, citing 
   Humberto Maturana and Francisco Varella's "Santiago Theory of Cognition"