Ruby/DB2 - now with Viper support!
Kellen Bombardier (who is a lead for the ibm_db2 and pdo_informix PECL packages) has been busy updating the work I started on integrating DB2 and Ruby.
It is now passes all the ibm_db2 PECL extension tests. I’ve tested it on both Ubuntu Linux and Windows XP. It works with either DB2 V8.2.4 and V 9.0.0 (Viper), though Viper’s XML support is not complete.
I guess at this point I should join in all the fun with acroynms. If you start with LAMP and substitute in Ruby and DB2, you get LADR. Kinda uplifting (hah!), eh? And if you felt so inclined (hah!) you could even add in Derby and Eclipse to complete the word.
Tim might prefer Solaris, but frankly that would be… (wait for it)… SADDER.
I’ve followed the instructions included in the README (for Windows XP).
Typing “rake” produces this output:
(in c:/rubydb2)
c:/ruby/bin/ruby tests.rb
and causes an error pop-up titled:
“ruby.exe - Unable To Locate Component”
with this error message:
“This application failed to start because MSVCR80.dll was not found.”
I’d appreciate nay pointers you could supply as to where I can find a solution for this problem.
Thanks
MSVCR71.DLL should be provided by C:\Program Files\Microsoft Platform SDK for Windows Server 2003 R2\SetEnv.Cmd.
I’m confident that Microsoft will be glad to sell you a product which contains everything you need. What they make available for free is missing a few key things like “.lib” files for the C Runtime itself (MSVCR = MicroSoft Visual C Runtime). However, these can be found at alternative sources.
The problem is that you have to make sure that you pick up a consistent set. No mixing V7 with V8 or... kaboom!
My recommendation is to first pare back your PATH and LIB to the bare minimum. For me, it is something like this:
SET PATH=c:\ruby\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\PROGRA~1\IBM\SQLLIB\BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION;C:\PROGRA~1\IBM\SQLLIB\SAMPLES\REPL SET LIB=;C:\PROGRA~1\IBM\SQLLIB\LIB
Then run:
@CALL "C:\Program Files\Microsoft Platform SDK for Windows Server 2003 R2\SetEnv.Cmd" @CALL "C:\Program Files\Microsoft Visual C++ Toolkit 2003\vcvars32.bat" @SET LIB=%LIB%;C:\Program Files\Microsoft Visual Studio .NET 2003\Vc7\lib
Now, from this same window, try rake again.
Sam Ruby: Ruby/DB2 - now with Viper support!
not too surprising; Sam’s doing the right thing again - be great to see full XML support...Excerpt from del.icio.us/sogrady/ruby at
links for 2006-05-08
Brian “Krow” Aker’s Idle Thoughts - Thoughts on Flat Files vs Databases interesting commentary on when flat files should be used over a DB, and how DB’s should evolve to be more web server friendly (tags: web server MySQL flat files databases...Excerpt from tecosystems at