Dbi BUG?

ruby-talk
1

I downloaded and installed the latest release of dbi (0.0.18) and ran the following test using ADO:

-------------------------

require ‘dbi’

URL = ‘dbi:ADO:Provider=SQLOLEDB;Data Source=(local);’ +
‘Initial Catalog=master;User Id=sa;Password=;’

DBI.connect(URL) do |dbh|

i = 0
sql = “select * from dbo.sysindexes”

sth = dbh.execute(sql)
sth.fetch { |row|
i += 1
print i,’ '
p row
}

end

---------------------------

And I get:

    C:/ruby/lib/ruby/site_ruby/1.7/DBD/ADO/ADO.rb:216: [BUG] Segmentation fault

    This application has requested the Runtime to terminate it in an unusual way.
    Please contact the application's support team for more information.

The same code works for other tables if they are small ( < 60 rows).
Is this some kind of a memory issue ?

I am using ruby 1.7.3 (2002-11-17) [i386-mswin32] on Win XP Pro.
The Database is SQL 2000 Developers Edition.

I had to uninstall the older version of dbi which was automatically installed by the
one-click Windows Installer before I could install this new release. I did this by manually
deleting files which caused the dbi install process to fail.

Did I do it wrong ?

Any help will be highly appreciated … TIA,
– shanko

2

I did not get this error when I ran it on ruby 1.7.3 (2002-10-12) [i386-mswin32] on Win 2K Pro.
Everything else was the same.
“Shashank Date” sdate@everestkc.net wrote in message news:003c01c2de0d$e13715e0$1f02a8c0@emachine…
I downloaded and installed the latest release of dbi (0.0.18) and ran the following test using ADO:

-------------------------

require ‘dbi’

URL = ‘dbi:ADO:Provider=SQLOLEDB;Data Source=(local);’ +
‘Initial Catalog=master;User Id=sa;Password=;’

DBI.connect(URL) do |dbh|

 i    =  0    
 sql = "select * from dbo.sysindexes"
  
 sth = dbh.execute(sql) 
 sth.fetch { |row|
      i += 1
      print i,' '
      p row
  }

end

---------------------------

And I get:

      C:/ruby/lib/ruby/site_ruby/1.7/DBD/ADO/ADO.rb:216: [BUG] Segmentation fault

      This application has requested the Runtime to terminate it in an unusual way.
      Please contact the application's support team for more information.

The same code works for other tables if they are small ( < 60 rows).
Is this some kind of a memory issue ?

I am using ruby 1.7.3 (2002-11-17) [i386-mswin32] on Win XP Pro.
The Database is SQL 2000 Developers Edition.

I had to uninstall the older version of dbi which was automatically installed by the
one-click Windows Installer before I could install this new release. I did this by manually
deleting files which caused the dbi install process to fail.

Did I do it wrong ?

Any help will be highly appreciated … TIA,
– shanko

3

Forgot to mention that this time there were warnings:

C:/RUBY/lib/ruby/1.7/rational.rb:316: warning: method redefined; discarding old div
C:/RUBY/lib/ruby/site_ruby/1.7/DBD/ADO/ADO.rb:52: warning: class variable ARGV of Object is overridden by WIN32OLE
C:/RUBY/lib/ruby/site_ruby/1.7/DBD/ADO/ADO.rb:126: warning: class variable ARGV of Object is overridden by WIN32OLE
C:/RUBY/lib/ruby/site_ruby/1.7/DBD/ADO/ADO.rb:192: warning: class variable ARGV of Object is overridden by WIN32OLE
C:/RUBY/lib/ruby/site_ruby/1.7/DBD/ADO/ADO.rb:216: warning: class variable ARGV of Object is overridden by WIN32OLE

Hope that means something to the experts.
Thanks,
– shanko
"Shashank Date" sdate@everestkc.net wrote in message

I did not get this error when I ran it on ruby 1.7.3 (2002-10-12) [i386-mswin32] on Win 2K Pro.
Everything else was the same.