Hi,

I'm trying to connect to DB2 from Ruby, and here are the steps i 
followed, but still no luck. Can any one please reply to me!

1)Installed Ruby 1.8.4
2)Installed ruby-db2-0.4.4
3)Installed MS VC 2003
4)Installed DB2

Configurations Done
=-=-=-=-=-=-=-=-=-=-
1)<MS VS Install DIR>\VC98\Bin\VCVARS32.BAT , such that MS environment 
variables are loaded to the current command line. also i'm able to 
execute the "cl" compiler command. Also have set the DB2DIR to 
"C:\Progra~1\IBM\SQLLIB". (DB2 location)

2)cd C:\temp\ruby-db2-0.4.4\ruby-db2-0.4.4

3)ruby setup.rb config

4)cd C:\temp\ruby-db2-0.4.4\ruby-db2-0.4.4\ext\db2

5)C:\temp\ruby-db2-0.4.4\ruby-db2-0.4.4\ext\db2>ruby extconf.rb 
--with-db2-include
=C:/Progra~1/IBM/SQLLIB/include 
--with-db2-lib=C:/Progra~1/IBM/SQLLIB/lib

checking for SQLConnect() in db2cli.lib... yes
checking for sqlcli.h... yes
creating Makefile

6)C:\temp\ruby-db2-0.4.4\ruby-db2-0.4.4\ext\db2>nmake

Microsoft (R) Program Maintenance Utility   Version 6.00.8168.0
Copyright (C) Microsoft Corp 1988-1998. All rights reserved.

c:\rubyInstall\bin\ruby -e "puts 'EXPORTS', 'Init_db2cli'"  > db2cli-i38
6-mswin32.def

cl -nologo -MD -Zi -O2b2xg- -G6 -I. -Ic:/rubyInstall/lib/ruby/1.8/i386-m
swin32 -Ic:/rubyInstall/lib/ruby/1.8/i386-mswin32 -I. -DHAVE_SQLCLI_H 
-IC:/Progr
a~1/IBM/SQLLIB/include -c -Tcdb2cli.c
db2cli.c
db2cli.c(1087) : warning C4761: integral size mismatch in argument; 
conversion s
upplied

cl -nologo -LD -Fedb2cli.so db2cli.obj msvcrt-ruby18.lib db2cli.lib  old
names.lib user32.lib advapi32.lib wsock32.lib  -link -incremental:no 
-debug -opt
:ref -opt:icf -dll -libpath:"C:/Progra~1/IBM/SQLLIB/lib" 
-libpath:"c:/rubyInstal
l/lib" -def:db2cli-i386-mswin32.def -implib:db2cli-i386-mswin32.lib 
-pdb:db2cli-
i386-mswin32.pdb

Creating library db2cli-i386-mswin32.lib and object 
db2cli-i386-mswin32.exp

7)C:\temp\ruby-db2-0.4.4\ruby-db2-0.4.4>ruby setup.rb install
setup.rb:714: warning: don't put space before argument parentheses
entering install phase...
mkdir -p c:/rubyInstall/lib/ruby/site_ruby/1.8/db2
install db2cli.rb c:/rubyInstall/lib/ruby/site_ruby/1.8/db2
mkdir -p c:/rubyInstall/lib/ruby/site_ruby/1.8/i386-msvcrt/db2
install db2cli.so c:/rubyInstall/lib/ruby/site_ruby/1.8/i386-msvcrt/db2
install done.


8)When i go to C:\rubyInstall\lib\ruby\site_ruby\1.8\db2, i can see the 
file db2cli.rb
Also when i got to 
C:\rubyInstall\lib\ruby\site_ruby\1.8\i386-msvcrt\db2, i could see 
db2cli.so file

So far everything looked OK, but when i try to run the sample program 
for the connectivity i'm getting this error!!.. tried all options, but 
could not get away. Can any body please give a hand to me to resolve 
this..

Sample.rb
******************************************************************************
require 'dbi'

  DBI.connect('dbi:DB2:RESERVDB', 'db2admin', 'db2admin') do |dbh|
    p dbh.select_all('SELECT * FROM XMLFLIGHTTB')
  end
******************************************************************************
C:\temp\ruby-db2-0.4.4\ruby-db2-0.4.4\samples>Sample.rb
c:/rubyInstall/lib/ruby/site_ruby/1.8/dbi/dbi.rb:499:in `load_driver': 
is not a
 class/module (TypeError)
        from c:/rubyInstall/lib/ruby/site_ruby/1.8/dbi/dbi.rb:401:in 
`_get_full_
driver'
        from c:/rubyInstall/lib/ruby/site_ruby/1.8/dbi/dbi.rb:381:in 
`connect'
        from C:/temp/ruby-db2-0.4.4/ruby-db2-0.4.4/samples/saibaba.rb:3


Thanks
Dinesh

-- 
Posted via http://www.ruby-forum.com/.