From: tcfodor@...
Date: 2008-06-10T02:33:02+09:00
Subject: Ruby DBI class

Hi all!

I'm using the Ruby DBI class to create connections to both a MSSQL and
an Oracle database to verify the data migration between them is
successful.  My test works fine on XP, but on Vista (currently with
SP1, but my problem has always happened on Vista), I get a
segmentation fault when I perform my first select statement on the
Oracle database.  Select statements are performed against the MSSQL
database prior to the Oracle database and work fine.  I'm running the
test from a command prompt that has administrator privileges.

- Here's my Oracle connection:

@ora_connect = DBI.connect("DBI:ADO:Provider=OraOLEDB.Oracle;Data
Source=devserver;User Id=read_all;Password=password")


- Here is my method for running a select statement:

def getDBValue(connection, query, id1, *id2)
    dbi_query = connection.prepare(query)
    dbi_query.execute(id1, *id2)
    #fetch the result
    return dbi_query.fetch
end


- Here is the first Oracle select statement:

createDateTime = getDBValue(@ora_connect, "SELECT CREATED_TIME FROM
ORATEST.POLICY WHERE POLICYNUM = ?", policyNumber)


- Here is the error message I get:

c:/ruby/lib/ruby/site_ruby/1.8/DBD/ADO/ADO.rb:94: [BUG] Segmentation
fault ruby 1.8.6 (2007-03-13) [i386-mswin32]


Has anyone else seen this?  Does anyone have any ideas on workarounds
or how to fix it?

Thanks in advance for your help!

-Tiffany