unixODBC and FreeTDS in ROR


I Installed freeTDS, uniODBC everything need for to connect the MSSQL
server from ROR. I am able to connect the SQL server using isql command.
However, I am trying to connect the SQL server by the following line

@db = DBI.connect(‘dbi:ODBC:datasourcename’, ‘username’, ‘password’)

In the line, I got the below error
Unable to load driver ‘ODBC’ (underlying error: uninitialized constant

How can I solve this issue?

Otherwise please tell me if any other way (instead if freeTDS) we have
to connect the SQL server from ROR ?

  • Periyasamy