[Mono-dev] IBM.Data.DB2.DB2Exception: Unable to allocate statement handle

[Bartolomeo Nicolotti]

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.