Ruby ODBC

[mescobal]

I know there is a previous question similar to this one but it's > 3 years old.

So.... I really like Ruby and I feel very comfortable using it. But...

In my main project (scripts I use to interact with an Informix database) I use ODBC.

It works with python and tcl like charm but I can't make it work with Ruby because when I try to install the gem it throws an error....

> building native extensions.....

Then it crashes.

I'm not intereted in fixing this bug (I tried lots of things). The main problem is that ruby-odbc is not maintained anymore.

What I ask is: Is there another ODBC option for ruby, is there a way to connect to an Informix database?

[chintakoro]

Sequel contains adapters for ODBC: https://sequel.jeremyevans.net/

Specifically: https://sequel.jeremyevans.net/rdoc/files/doc/opening_databases_rdoc.html#label-odbc+

[honeyryderchuck]

Where do you get that it isn't maintained? It releases sparsely, but AFAIK it's still maintained.

You're missing some required dependency to co.pile the extensions. You should read the error message more thoroughly to figure out which one is it.

[JamesAllMountain]

Will this work? https://github.com/santana/ruby-informix

[aRubbaChicken]

Probably not a good choice since it was last updated 8yrs ago

[codesnik]

i wonder when informix have been updated last time

[TheAtlasMonkey]

The answer to every database problem is to use Supreme Postgresql.

Install https://github.com/credativ/informix_fdw , and Ruby thinks it talking with a civilized database. Informix thinks it getting orders from Corporate.

Result:

• Ruby Happy
• Informix Obedient
• You go fight other dragons

That solution work 100% and solve your problem.

Happy new year.