The project is in a healthy, maintained state
ActiveRecord SQL Server Adapter. SQL Server 2012 and upward.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
 Dependencies
 Project Readme

ActiveRecord SQL Server Adapter ODBC Extended

  • CI - CI

About The Adapter

This gem extends the ActiveRecord SQL Server adapter by adding enhanced functionality and customization, including ODBC support. It is compatible with both FreeTDS and ODBC connections.

We follow a versioning policy aligned with the ActiveRecord SQLServer Adapter. This means that version 8.x of this extended adapter corresponds to and supports the latest 8.x version of the activerecord-sqlserver-adapter gem.

We support the versions of the adapter that are in the Rails Bug Fixes maintenance group.

Adapter Version Rails Version Support Branch
8.0.x 8.0.x Active 8-0-stable

Using the TinyTDS Driver

If you are using the TinyTDS driver, please refer to the original gem’s README for setup and version details: https://github.com/rails-sqlserver/activerecord-sqlserver-adapter/tree/8-0-stable

Database configuration

Example:

development:
  adapter: sqlserver
  mode: 'dblib'
  host: 'localhost'
  port: 1433
  database: my_app_development
  username: 'frank_castle'
  password: 'secret'

Using the ODBC Driver

Features

  • Extends ActiveRecord::ConnectionAdapters::SQLServerAdapter
  • Adds custom connection logic and methods
  • Supports ODBC and DBLIB modes

Installation

  1. Add to Gemfile
gem 'activerecord-sqlserver-adapter-odbc-extended', '~> 8.0.9'
  1. Bundle install and Database configuration
bundle install

Example:

development:
  adapter: sqlserver
  mode: 'odbc'
  host: 'localhost'
  port: 1433
  database: my_app_development
  username: 'frank_castle'
  password: 'secret'

Contributing

Please contribute to the project by submitting bug fixes and features. To make sure your fix/feature has a high chance of being added, please include tests in your pull request. To run the tests you will need to setup your development environment.

Setting Up Your Development Environment

To run the test suite you can use any of the following methods below. See RUNNING_UNIT_TESTS for more detailed information on running unit tests.

Local Development

See the RUNNING_UNIT_TESTS file for the details of how to run the unit tests locally.

Credits & Contributions

License

ActiveRecord SQL Server Adapter with ODBC Support is released under the MIT License.