[Mono-list] IBM.Data.DB2 on ubuntu

[Bartolomeo Nicolotti]

Bartolomeo Nicolotti wrote:
> 
> 
> 
> Bojan Rajkovic wrote:
>> 
>> You're forgetting to add a reference to IBM.Data.DB2.dll on the gmcs
>> command
>> line.
>> 
>> You should be compiling your code as follows: gmcs
>> -r:/usr/lib/mono/1.0/IBM.Data.DB2.dll helloDB2.cs.
>> If your Mono libs are installed somewhere different (if you compiled from
>> source, they may be in /usr/local/lib/mono), you'll need to change that
>> part
>> of the path.
>> 
>> --Bojan
>> 
>> -----Original Message-----
>> From: mono-list-bounces at lists.ximian.com
>> [mailto:mono-list-bounces at lists.ximian.com] On Behalf Of Bartolomeo
>> Nicolotti
>> Sent: Tuesday, February 10, 2009 12:20 PM
>> To: mono-list at lists.ximian.com
>> Subject: [Mono-list] IBM.Data.DB2 on ubuntu
>> 
>> 
>> Hi,
>> 
>> I've installed mono, and xsp (not yet mod_mono) 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.
>> 
>> This is to migrate a web service that access a db2 database.
>> 
>> I've also installed db2exc from ubuntu repository as said here:
>> 
>> http://www.ubuntu.com/partners/ibm/db2
>> 
>> and as said here:
>> 
>> http://www.mail-archive.com/mono-devel-list@lists.ximian.com/msg02323.html
>> 
>> I've added the library path with the command:
>> 
>> sudo /sbin/ldconfig /opt/ibm/db2exc/V9.5/lib32
>> 
>> But if I try to compile a file that makes use of the namespace
>> IBM.Data.DB2
>> I got:
>> 
>> siap at LxPC54:~/src/test$ gmcs helloDB2.cs 
>> helloDB2.cs(2,14): error CS0234: The type or namespace name `Data' does
>> not
>> exist in the namespace `System'. Are you missing an assembly reference?
>> helloDB2.cs(3,7): error CS0246: The type or namespace name `IBM' could
>> not
>> be found. Are you missing a using directive or an assembly reference?
>> Compilation failed: 2 error(s), 0 warnings
>> 
>> 
>> could someone help me?
>> 
>> Many thanks 
>> 
>> Best regards
>> -- 
>> View this message in context:
>> http://www.nabble.com/IBM.Data.DB2-on-ubuntu-tp21937603p21937603.html
>> Sent from the Mono - General mailing list archive at Nabble.com.
>> 
>> _______________________________________________
>> Mono-list maillist  -  Mono-list at lists.ximian.com
>> http://lists.ximian.com/mailman/listinfo/mono-list
>> 
>> 
>> _______________________________________________
>> Mono-list maillist  -  Mono-list at lists.ximian.com
>> http://lists.ximian.com/mailman/listinfo/mono-list
>> 
>> 
> 
> 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 
> siap at LxPC54:~/src/test$ mono helloDB2.exe 
> You must tell me your name!
> siap at LxPC54:~/src/test$ mono helloDB2.exe bart
> Hello, bart
> 
> Unhandled Exception: System.DllNotFoundException: db2_36
>   at (wrapper managed-to-native)
> IBM.Data.DB2.DB2CLIWrapper/StaticWrapper36:SQLAllocHandle
> (int16,intptr,intptr&)
>   at IBM.Data.DB2.DB2CLIWrapper.SQLAllocHandle (Int16 handleType, IntPtr
> inputHandle, System.IntPtr& outputHandle) [0x00000] 
>   at IBM.Data.DB2.DB2CLIWrapper.Initialize (System.IntPtr& pEnvHandle)
> [0x00000] 
>   at IBM.Data.DB2.DB2Environment..ctor () [0x00000] 
>   at IBM.Data.DB2.DB2Environment.get_Instance () [0x00000] 
>   at IBM.Data.DB2.DB2ConnectionPool.FindConnectionPool (System.String
> connectionString) [0x00000] 
>   at IBM.Data.DB2.DB2ConnectionSettings.GetConnectionSettings
> (System.String connectionString) [0x00000] 
>   at IBM.Data.DB2.DB2Connection.SetConnectionString (System.String
> connectionString) [0x00000] 
>   at IBM.Data.DB2.DB2Connection..ctor (System.String conString) [0x00000] 
>   at (wrapper remoting-invoke-with-check) IBM.Data.DB2.DB2Connection:.ctor
> (string)
>   at HelloWorldDb2.Main (System.String[] args) [0x00000] 
> 
> 
> 

sudo vim /etc/mono/config

        <dllmap dll="oci" target="libclntsh.so" os="!windows"/>
        <dllmap dll="db2cli" target="libdb2_36.so" os="!windows"/>
        <dllmap dll="db2_36" target="libdb2.so" os="!windows"/>
 
-- 
View this message in context: http://www.nabble.com/IBM.Data.DB2-on-ubuntu-tp21937603p21939352.html
Sent from the Mono - General mailing list archive at Nabble.com.