tag:blogger.com,1999:blog-19765234.post8916266426667514471..comments2023-11-05T03:51:05.353-06:00Comments on Santana's Tech Notes: ibm_db and Ruby/Informix interface comparisonGerardohttp://www.blogger.com/profile/17820570857823361035noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-19765234.post-72592142999637646562008-04-01T10:23:00.000-06:002008-04-01T10:23:00.000-06:00Great :)Those firewall problems can be a headache....Great :)<BR/><BR/>Those firewall problems can be a headache.<BR/><BR/>By the way, I've just released Ruby/Informix 0.7.0. It has a hand of new nice features you may want to check.<BR/><BR/>I'll blog about it later.Gerardohttps://www.blogger.com/profile/17820570857823361035noreply@blogger.comtag:blogger.com,1999:blog-19765234.post-72937904255530779802008-04-01T10:10:00.000-06:002008-04-01T10:10:00.000-06:00Gerardo - You're the man. Turns out my problem was...Gerardo - You're the man. Turns out my problem was a firewall issue. Once that was resolved I was able to make an Informix connection and retrieve data with a simple select.<BR/><BR/>Thanks so much!<BR/><BR/>Donjonahbluehttps://www.blogger.com/profile/03011483394988210182noreply@blogger.comtag:blogger.com,1999:blog-19765234.post-88681389648365348452008-03-26T10:46:00.000-06:002008-03-26T10:46:00.000-06:00Let's use finderr to know more about the problem. ...Let's use finderr to know more about the problem. Type this at the command prompt:<BR/><BR/>finderr -908<BR/><BR/>It seems that you system can't reach solomon.asbury.edu at port 1023, or it's too busy.<BR/><BR/>Verify that you can access that server at that port. You can do something like this:<BR/><BR/>telnet solomon.asbury.edu 1023<BR/><BR/>You should get something like this:<BR/><BR/>Trying #.Gerardohttps://www.blogger.com/profile/17820570857823361035noreply@blogger.comtag:blogger.com,1999:blog-19765234.post-87110885188291163222008-03-26T08:59:00.000-06:002008-03-26T08:59:00.000-06:00Thank you for your reply, Gerardo.Your irb suggest...Thank you for your reply, Gerardo.<BR/><BR/>Your irb suggestion times out with:<BR/><BR/>irb(main):004:0> Informix.connect("kampus@katalyst")<BR/>Informix::DatabaseError: <BR/>message : Client unable to establish connection<BR/>sql_code : -908<BR/>sql_state : 08004<BR/>class_origin : ISO 9075<BR/>subclass_origin: ISO 9075<BR/><BR/>message : ISAM error: record is lockedjonahbluehttps://www.blogger.com/profile/03011483394988210182noreply@blogger.comtag:blogger.com,1999:blog-19765234.post-33412445908115919072008-03-25T10:45:00.000-06:002008-03-25T10:45:00.000-06:00Hello Don,Ok, according to the error message, ther...Hello Don,<BR/><BR/>Ok, according to the error message, there's a problem establishing a connection. It is usually a problem in the sqlhosts or SetNet32 configuration, or we are specifying the database name incorrectly.<BR/><BR/>For debugging this, we can do by hand what the Rails environment is doing. Take the value of :database located in your database.yml and use it as an argument to Gerardohttps://www.blogger.com/profile/17820570857823361035noreply@blogger.comtag:blogger.com,1999:blog-19765234.post-85436410909296697592008-03-25T06:57:00.000-06:002008-03-25T06:57:00.000-06:00Hi Gerardo,I tried connecting a new Ruby on Rails ...Hi Gerardo,<BR/>I tried connecting a new Ruby on Rails app to our legacy Informix database about a year and a half ago, and though you were kind enough to email me a few times, I could never get it working and had to move on to other things. Well, now I'm trying again, and while I'm following instructions, I'm getting a timeout after 80 seconds:<BR/><BR/>Informix::DatabaseError in jonahbluehttps://www.blogger.com/profile/03011483394988210182noreply@blogger.com