[Mono-dev] IBM.Data.DB2.DB2Exception: Unable to allocate statement handle
Bartolomeo Nicolotti
bnicolotti at siapcn.it
Thu Feb 12 12:26:25 EST 2009
Hi,
I don't know If I'm saying something with sense, but in the source tree of
mono 2.2 there's a folder called
mcs/Classes/IBM.Data.DB2,
If you install db2 express c you get a folder with the file libcdb2.so:
/opt/ibm/.../lib32/libcdb2.so
and if you edit
sudo vim /usr/local/etc/mono/config
adding this line: ... <dllmap dll="db2_36" target="libdb2.so.1"
os="!windows"/> ...
the "links" sould be ok, and you sould have the same as in IBM.Data.DB2.dll,
am I right?
Daniel Morgan-3 wrote:
>
> IBM does not provide an IBM.Data.DB2.dll assembly for Linux. IBM only
> provides IBM.Data.DB2.dll for Windows. This goes the same with other
> proprietary database management systems out there, such as, Oracle and
> Sybase. These companies only support Microsoft .net framework - they do
> not even acknowledge Mono.
>
> Mono provides a homemade IBM.Data.DB2.dll assembly, but it is not
> maintained.
>
> I cannot see what is available on Linux right now, but I can see what the
> Mono Windows installer installs. Mono only installs IBM.Data.DB2.dll for
> the 1.0 profile. The assembly is not built for the 2.0 profile.
>
> I suggest using System.Data.Odbc instead. Novell does maintain
> System.Data.Odbc, and IBM does have an ODBC driver for DB2 on Linux.
>
> --- On Thu, 2/12/09, Carlos Ruiz Diaz <carlos.ruizdiaz at gmail.com> wrote:
>
>> From: Carlos Ruiz Diaz <carlos.ruizdiaz at gmail.com>
>> Subject: Re: [Mono-dev] IBM.Data.DB2.DB2Exception: Unable to allocate
>> statement handle
>> To: "Bartolomeo Nicolotti" <bnicolotti at siapcn.it>
>> Cc: mono-devel-list at lists.ximian.com
>> Date: Thursday, February 12, 2009, 10:46 AM
>> After failing trying to connect with the native driver I
>> switched to
>> unixODBC and it works fine for me. It is stable and I
>> currently have a large
>> program using ODBC as its connector.
>> I use openSuse as my major OS. I installed the db2 express
>> C but I was
>> unable to find the required library to make IBM.DB2 dll to
>> work. Bad for me.
>>
>>
>>
>>
>> On Thu, Feb 12, 2009 at 4:20 AM, Bartolomeo Nicolotti
>> <bnicolotti at siapcn.it>wrote:
>>
>> >
>> > I'd like to use the webservice "As is"
>> so that we can switch easyly...
>> >
>> > if I won't be able to do it with IBM.Data.DB2 in a
>> few days I'll consider
>> > using other way to connect.
>> >
>> > Do you know if with these providers you can connecto
>> to AS/400?
>> >
>> > Many thanks
>> >
>> > Best regards
>> >
>> >
>> >
>> > Bartolomeo Nicolotti wrote:
>> > >
>> > > Da: Daniel Morgan <monodanmorg at yahoo.com>
>> > >
>> > > Have you considered using ODBC provider instead?
>> > >
>> > > System.Data.Odbc namespace is included in
>> System.Data assembly.
>> > >
>> > > You can use iodbc or unixodbc on linux.
>> There's commercial odbc
>> > solutions
>> > > for linux too.
>> > >
>> > > http://mono-project.com/ODBC
>> > >
>> > > http://www.unixodbc.com/doc/db2.html
>> > >
>> > > Novell maintains System.Data.Odbc; however, I do
>> not think anyone is
>> > > maintaining IBM.Data.DB2 in Mono.
>> > >
>> > >
>> > > --- On Wed, 2/11/09, Bartolomeo Nicolotti
>> <bnicolotti at siapcn.it> wrote:
>> > >
>> > >
>> > >
>> > > Bartolomeo Nicolotti wrote:
>> > >>
>> > >> IBM.Data.DB2.DB2Exception: Unable to allocate
>> statement handle
>> > >>
>> > >> by Bartolomeo Nicolotti :: Rate this Message:
>> > >>
>> > >> Reply | Reply to Author | View Threaded |
>> Show Only this Message
>> > >> Hello,
>> > >>
>> > >> I've installed mono, and xsp (not yet
>> mod_mono) on ubuntu following the
>> > >> instruction here:
>> > >>
>> > >>
>> http://ubuntuforums.org/showthread.php?t=803743
>> > >>
>> > >> in view of using mod_mono together with php
>> on ubuntu server 8.04, to
>> > >> migrate a web service that access a db2/as400
>> database.
>> > >>
>> > >> I've also installed db2exc from ubuntu
>> repository as said here:
>> > >>
>> > >> http://www.ubuntu.com/partners/ibm/db2
>> > >>
>> > >> I can compile a test program that does a
>> query to the db:
>> > >>
>> > >>
>> http://www.nabble.com/file/p21953488/helloDB2.cs helloDB2.cs
>> > >>
>> > >> siap at LxPC54:~/src/test$ gmcs
>> -r:/usr/lib/mono/1.0/IBM.Data.DB2.dll
>> > >> -r:/usr/lib/mono/2.0/System.Data.dll
>> helloDB2.cs
>> > >>
>> > >> but when I execute it:
>> > >>
>> > >> siap at LxPC54:~/src/test$ sudo
>> MONO_LOG_LEVEL=debug mono helloDB2.exe
>> > bart
>> > >>
>> > >> ....
>> > >>
>> > >> Mono-INFO: Assembly Ref addref System.Data
>> 0x8362e10 -> System.Xml
>> > >> 0x83719d8: 2
>> > >>
>> > >> Hello, bart
>> > >> Mono-INFO: DllImport attempting to load:
>> 'libdb2'.
>> > >> Mono-INFO: DllImport loading location:
>> 'libdb2.so'.
>> > >> Mono-INFO: Searching for
>> 'SQLAllocHandle'.
>> > >> Mono-INFO: Probing 'SQLAllocHandle'.
>> > >> Mono-INFO: Found as 'SQLAllocHandle'.
>> > >> Mono-INFO: DllImport attempting to load:
>> 'libdb2'.
>> > >> Mono-INFO: DllImport loading location:
>> 'libdb2.so'.
>> > >> Mono-INFO: Searching for
>> 'SQLAllocHandle'.
>> > >> Mono-INFO: Probing 'SQLAllocHandle'.
>> > >> Mono-INFO: Found as 'SQLAllocHandle'.
>> > >> Bart
>> > >> not useLibCli
>> > >> Bart
>> > >> not useLibCli
>> > >> Mono-INFO: DllImport attempting to load:
>> 'libdb2'.
>> > >> Mono-INFO: DllImport loading location:
>> 'libdb2.so'.
>> > >> Mono-INFO: Searching for
>> 'SQLDriverConnectW'.
>> > >> Mono-INFO: Probing
>> 'SQLDriverConnectWW'.
>> > >> Mono-INFO: Probing
>> 'SQLDriverConnectWW'.
>> > >> Mono-INFO: Probing
>> 'SQLDriverConnectW'.
>> > >> Mono-INFO: Found as
>> 'SQLDriverConnectW'.
>> > >> Mono-INFO: DllImport attempting to load:
>> 'libdb2'.
>> > >> Mono-INFO: DllImport loading location:
>> 'libdb2.so'.
>> > >> Mono-INFO: Searching for
>> 'SQLDriverConnectW'.
>> > >> Mono-INFO: Probing
>> 'SQLDriverConnectWW'.
>> > >> Mono-INFO: Probing
>> 'SQLDriverConnectWW'.
>> > >> Mono-INFO: Probing
>> 'SQLDriverConnectW'.
>> > >> Mono-INFO: Found as
>> 'SQLDriverConnectW'.
>> > >> Mono-INFO: DllImport attempting to load:
>> 'libdb2'.
>> > >> Mono-INFO: DllImport loading location:
>> 'libdb2.so'.
>> > >> Mono-INFO: Searching for
>> 'SQLGetInfoW'.
>> > >> Mono-INFO: Probing 'SQLGetInfoWW'.
>> > >> Mono-INFO: Probing 'SQLGetInfoWW'.
>> > >> Mono-INFO: Probing 'SQLGetInfoW'.
>> > >> Mono-INFO: Found as 'SQLGetInfoW'.
>> > >> Mono-INFO: DllImport attempting to load:
>> 'libdb2'.
>> > >> Mono-INFO: DllImport loading location:
>> 'libdb2.so'.
>> > >> Mono-INFO: Searching for
>> 'SQLGetInfoW'.
>> > >> Mono-INFO: Probing 'SQLGetInfoWW'.
>> > >> Mono-INFO: Probing 'SQLGetInfoWW'.
>> > >> Mono-INFO: Probing 'SQLGetInfoW'.
>> > >> Mono-INFO: Found as 'SQLGetInfoW'.
>> > >> Mono-INFO: DllImport attempting to load:
>> 'libdb2'.
>> > >> Mono-INFO: DllImport loading location:
>> 'libdb2.so'.
>> > >> Mono-INFO: Searching for
>> 'SQLGetDiagRec'.
>> > >> Mono-INFO: Probing 'SQLGetDiagRec'.
>> > >> Mono-INFO: Found as 'SQLGetDiagRec'.
>> > >> Mono-INFO: DllImport attempting to load:
>> 'libdb2'.
>> > >> Mono-INFO: DllImport loading location:
>> 'libdb2.so'.
>> > >> Mono-INFO: Searching for
>> 'SQLGetDiagRec'.
>> > >> Mono-INFO: Probing 'SQLGetDiagRec'.
>> > >> Mono-INFO: Found as 'SQLGetDiagRec'.
>> > >> Bart
>> > >> not useLibCli
>> > >>
>> > >> Unhandled Exception:
>> IBM.Data.DB2.DB2Exception: ERROR [08003] [IBM][CLI
>> > >> Driver] CLI0106E Connection is closed.
>> SQLSTATE=08003
>> > >> InternalExecuteNonQuery: Unable to allocate
>> statement handle.
>> > >> at
>> IBM.Data.DB2.DB2Command.AllocateStatement (System.String
>> location)
>> > >> [0x00000]
>> > >> at
>> IBM.Data.DB2.DB2Command.ExecuteNonQueryInternal
>> (CommandBehavior
>> > >> behavior) [0x00000]
>> > >> at IBM.Data.DB2.DB2Command.ExecuteReader
>> (CommandBehavior behavior)
>> > >> [0x00000]
>> > >> at IBM.Data.DB2.DB2Command.ExecuteReader ()
>> [0x00000]
>> > >> at (wrapper remoting-invoke-with-check)
>> > >> IBM.Data.DB2.DB2Command:ExecuteReader ()
>> > >> at HelloWorldDb2.Main (System.String[]
>> args) [0x00000]
>> > >>
>> > >
>> > >
>> >
>> > --
>> > View this message in context:
>> >
>> http://www.nabble.com/IBM.Data.DB2.DB2Exception%3A-Unable-to-allocate-statement-handle-tp21953488p21971698.html
>> > Sent from the Mono - Dev mailing list archive at
>> Nabble.com.
>> >
>> > _______________________________________________
>> > Mono-devel-list mailing list
>> > Mono-devel-list at lists.ximian.com
>> >
>> http://lists.ximian.com/mailman/listinfo/mono-devel-list
>> >
>> _______________________________________________
>> Mono-devel-list mailing list
>> Mono-devel-list at lists.ximian.com
>> http://lists.ximian.com/mailman/listinfo/mono-devel-list
>
>
>
> _______________________________________________
> Mono-devel-list mailing list
> Mono-devel-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-devel-list
>
>
--
View this message in context: http://www.nabble.com/IBM.Data.DB2.DB2Exception%3A-Unable-to-allocate-statement-handle-tp21953488p21980744.html
Sent from the Mono - Dev mailing list archive at Nabble.com.
More information about the Mono-devel-list
mailing list