From: Bob Smyph <ramsee@...>
Date: 2010-09-17T03:24:27+09:00
Subject: Re: Connect to IBM_DB with rubyscript2exe

> First off, I highly recommend switching to OCRA
> (http://rubygems.org/gems/ocra) over rubyscript2exe, as rubyscript2exe
> has been discontinued for almost 3 years.  That alone may fix your 
> issue.
> 
> If it doesn't, could you provide more information, like the exact text
> of the error message and a small script that reproduces the problem?

I have tried to install OCRA but keep getting a ton of errors.

so i would like to be able to use what i had. below is a script that 
works when i run it as a .rb but when i make it a .exe through 
rubyscript2exe it no longer will connect to the DB. the DBname is 
cataloged if that makes any difference
---------
require 'mswin32/ibm_db'

sql = "select * from statement where row = '1'"
dbh = IBM_DB::connect(databaseName, "", "")
sth = IBM_DB::exec(dbh, sql)
holdA = IBM_DB::fetch_array(sth)

puts holdA[0]
---------
-- 
Posted via http://www.ruby-forum.com/.