search

TalentBox / sequel-rails

A gem for using Sequel with Rails 5.x, 6.x, 7.x, 8.x
http://talentbox.github.io/sequel-rails/
MIT License
326 stars 81 forks source link

ODBC Support #76

Open philomory opened 9 years ago

philomory commented 9 years ago

I'm using sequel-rails to connect to an SQL Server instance via ODBC; it seems to work just fine in development mode without any tweaking - I can open the rails console and create records, at least - but when I try to run rake db:test:prepare it says, "Adapter odbc not supported (:Odbc)" during the db:drop subtask.

I did see issue #61, but I'm not sure the suggestion there applies, since I do intend to use Sequel::Model.

JonathanTron commented 9 years ago

Hi @philomory, thanks for reporting this issue. There is currently no support for ODBC in sequel-rails, and no explicit support for SQL Server.

The suggestion in #61 depends on your requirements, sequel-rails hooks into various places of Rails to give you a similar experience to what you would have when using ActiveRecord. But in order to do that it requires to have specific implementation for each supported database and connection method (jdbc, odbc, specific driver, ...).

Adding ODBC support could be done, but testing and thus maintaining it is not trivial. I would be inclined to accept such contribution only with good test coverage running at least on TravisCI.

Thanks again for reporting it.