From: Daniel Berger <djberg96@...>
Date: 2008-06-10T04:35:42+09:00
Subject: Re: Ruby DBI class



On Jun 9, 11:33 am, tcfo...@gmail.com wrote:
> 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!

What version of Ruby and DBI are you using? Line 94 of my ADO.rb file
is just a comment. Can you paste that line at least?

Thanks,

Dan