# Strange dbi

**URL:** <https://www.ruby-forum.com/t/strange-dbi/64863>\
**Category:** Ruby\
**Created:** [August 15, 2006, 2:19pm UTC](https://www.ruby-forum.com/t/strange-dbi/64863 "2006-08-15T14:19:56Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![johnf](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/848f3c/32.png) [@johnf](https://www.ruby-forum.com/u/johnf)\
**Post date:** [August 15, 2006, 2:19pm UTC](https://www.ruby-forum.com/t/strange-dbi/64863/1 "2006-08-15T14:19:56Z")

</div>

Hi,

First I’m a newbie to ruby. I’m using SUSE 10.0, ruby 1.8.2, dbi,  
freetds,  
unixODBC. I’m just testing access to a MS SQL 2000 database. I also  
posted this on the forum but no one responsed for two days.

code:  
require ‘dbi’  
db = DBI.connect(‘dbi:ODBC:mssql’,‘username’,‘password’)

rows = db.select\_all(“select \* from arcust”)

error messages:  
/usr/lib/ruby/site\_ruby/1.8/DBD/ODBC/ODBC.rb:239:in `fetch': INTERN (0) [RubyODBC]No data found (DBI::DatabaseError) from /usr/lib/ruby/site_ruby/1.8/dbi.rb:995:in`fetch\_all’  
from /usr/lib/ruby/site\_ruby/1.8/dbi.rb:994:in `loop' from /usr/lib/ruby/site_ruby/1.8/dbi.rb:994:in`fetch\_all’  
from /usr/lib/ruby/site\_ruby/1.8/dbi.rb:759:in `fetch_all' from /usr/lib/ruby/site_ruby/1.8/dbi.rb:515:in`select\_all’  
from /usr/lib/ruby/site\_ruby/1.8/dbi.rb:511:in `execute' from /usr/lib/ruby/site_ruby/1.8/dbi.rb:511:in`select\_all’  
from rubytest.rb:4

However, if I change the sql statement to:  
rows = db.select\_all(“select custno,company from arcust”)  
ALL WORKS. Does anyone have any thoughts regarding why this is  
happening?

John