Thanks for the reply but for this project I really need to use ruby.
[GIT_signature] Wesley Staples Senior Helpdesk Specialist From: [email protected] [mailto:[email protected]] On Behalf Of Simon Dahlbacka Sent: Thursday, September 19, 2013 8:57 AM To: [email protected] Subject: Re: Ubuntu 12.04 64-bit – Sequel – iSeries Not directly on topic, but I'd suggest using jruby and jtopen (jt400.jar) regards, Simon On Thu, Sep 19, 2013 at 3:31 PM, Wesley Staples <[email protected]<mailto:[email protected]>> wrote: I’m attempting to connect to an iSeries database with Sequel / ODBC. Everything works fine on the 32-bit version of Ubuntu and on windows however for some reason using the same code on a 64-bit system I’m getting the error: /home/helpdesk/.rvm/gems/ruby-2.0.0-p247/gems/sequel-4.2.0/lib/sequel/adapters/odbc.rb:109:in `fetch_all': failed to allocate memory (NoMemoryError) from /home/helpdesk/.rvm/gems/ruby-2.0.0-p247/gems/sequel-4.2.0/lib/sequel/adapters/odbc.rb:109:in `block in fetch_rows' from /home/helpdesk/.rvm/gems/ruby-2.0.0-p247/gems/sequel-4.2.0/lib/sequel/adapters/odbc.rb:42:in `block in execute' from /home/helpdesk/.rvm/gems/ruby-2.0.0-p247/gems/sequel-4.2.0/lib/sequel/database/connecting.rb:229:in `block in synchronize' from /home/helpdesk/.rvm/gems/ruby-2.0.0-p247/gems/sequel-4.2.0/lib/sequel/connection_pool/threaded.rb:104:in `hold' from /home/helpdesk/.rvm/gems/ruby-2.0.0-p247/gems/sequel-4.2.0/lib/sequel/database/connecting.rb:229:in `synchronize' from /home/helpdesk/.rvm/gems/ruby-2.0.0-p247/gems/sequel-4.2.0/lib/sequel/adapters/odbc.rb:39:in `execute' from /home/helpdesk/.rvm/gems/ruby-2.0.0-p247/gems/sequel-4.2.0/lib/sequel/dataset/actions.rb:793:in `execute' from /home/helpdesk/.rvm/gems/ruby-2.0.0-p247/gems/sequel-4.2.0/lib/sequel/adapters/odbc.rb:104:in `fetch_rows' from /home/helpdesk/.rvm/gems/ruby-2.0.0-p247/gems/sequel-4.2.0/lib/sequel/dataset/actions.rb:143:in `each' from odbc_test.rb:7:in `<main>' I started with ruby 1.9.3 but upgraded to 2.0 with the same result. Any thoughts on what I can check? I can connect with isql fine: isql -v GBAS400 +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> SELECT TABLE_NAME FROM QSYS2.SYSTABLES WHERE TABLE_NAME = 'SYSTABLES' +---------------------------------------------------------------------------------------------------------------------------------+ | TABLE_NAME | +---------------------------------------------------------------------------------------------------------------------------------+ | SYSTABLES | | SYSTABLES | | SYSTABLES | | SYSTABLES | | SYSTABLES | | SYSTABLES | +---------------------------------------------------------------------------------------------------------------------------------+ SQLRowCount returns -1 6 rows fetched SQL> -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:sequel-talk%[email protected]>. To post to this group, send email to [email protected]<mailto:[email protected]>. Visit this group at http://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to a topic in the Google Groups "sequel-talk" group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/sequel-talk/1Q3GEY4tqKg/unsubscribe. To unsubscribe from this group and all its topics, send an email to [email protected]<mailto:[email protected]>. To post to this group, send email to [email protected]<mailto:[email protected]>. Visit this group at http://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/groups/opt_out.
<<inline: image001.png>>
