From: lorenzo Date: 2007-11-24T02:20:28+09:00 Subject: Re: ODBC and Ruby On 2007-11-23 17:32:25 +0100, Gerardo Santana G�mez Garrido said: Hello, Is not so easy, I'm using Macosx and I don' have informix sdk for it Have you any ideas? Thank you :) > Hello Lorenzo, > > On Nov 23, 2007 7:55 AM, lorenzo wrote: >> hello, I'm new in ruby, I've problems conneting ruby odbc with informix >> db, in tbles with thousand records my program always retruns no rows, >> >> this is the test program: >> >> sth=c.prepare("select * from anopta") >> >> sth.execute >> if sth.ncols == 0 then >> puts "Statement has no result set" >> printf "Number of rows affected: %d\n", sth.nrows >> else >> puts "Statement has a result set" >> sth.fetch_all >> printf "Number of rows: %d\n", sth.nrows >> printf "Number of columns: %d\n", sth.ncols >> end >> >> >> this is the output >> >> Statement has a result set >> Number of rows: -1 >> Number of columns: 5 >> >> The table has 5 colums and 300 rows >> >> I don't know if this problem is specific for informix databases >> >> thank u very much > > May I suggest you to try the Informix extension instead? > > http://ruby-informix.rubyforge.org