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

[Rafael Teixeira]

Well, you have to download and install Oracle Client from Oracle to be
able to access an Oracle Database with any of the alternatives
(specific ADO.NET provider, OLEDB, ODBC).  That is why that bug case
was closed with NOTABUG.

I could not find any open source alternative that directly connects to
the Oracle Server,  all the ones I've found (like the ones for PHP,
PERL, Python) just wrap, and so depend on, the OCI libraries installed
by the Oracle Client installer.

That is a different situation from trying to connect to a MS SQL
Server, whose line protocol has been reverse engineered, and so we
have, as in Mono, completely open/free implementations of the client
stack.

Hope it clarifies things a bit,

On Wed, 15 Sep 2004 11:31:00 +0200, Gomez Aragoneses, Andres
<agomez at wke.es> wrote:
> 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

-- 
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"