How to connect to SQL Server 2005 database through Ruby

Question

How to connect to SQL Server 2005 database through Ruby in Windows

Answer 1

Here's an example.

Answer 2

Here's an example using Ruby and ADO to connect to and query an SQL Server database:

http://rubyonwindows.blogspot.com/2007/03/ruby-ado-and-sqlserver.html

And this article demonstrates how to use Ruby and SQL-DMO to automate server tasks:

http://rubyonwindows.blogspot.com/2007/09/using-ruby-sql-dmo-to-automate-sql.html

David