Ruby Connecting to SQL Server 2005

Question

I want to connect to sql 2005 / db server with ODBC through ruby ​​using windows authentication. I have the dbi-0.4.1 and dbd-odbc-0.2.4 gems installed. What do I need to do for the connection string? So far I have not been able to get it to work.

DBI.connect ("DBI: ODBC: Data Source = # {server}; Integrated Security = SSPI; Start Directory = # {db}")

Answer 1

Appears after specifying DBI: DriverName: you can specify any available connection information.

DBI.connect ("DBI: ODBC: Driver = {SQL Server}; Server = # {server}; Database = # {db}; Trusted_Connection = yes")

http://www.devlist.com/ConnectionStringsPage.aspx

Answer 2

:

DBI.connect( 'DBI: ODBC: ')