CODEWITHSUNDEEP
sql-serverrubydatabasesql-server-2005connection
Praveen
Praveen

Reputation: 11

How to connect to SQL Server 2005 database through Ruby

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

Upvotes: 1

Views: 774

Answers (2)

the Tin Man
the Tin Man

Reputation: 160551

I have luck using FreeTDS and TinyTDS on Linux. I prefer that path because messing with ODBC was a pain.

In addition, I recommend using the Sequel ORM, because it helps remove the task of dealing with different flavors of SQL, allowing us to concentrate on programming, not writing queries that are tied to a particular DBM.

Upvotes: 1

David Mullet
David Mullet

Reputation: 436

"Ruby, ADO, and SQLServer" is an example using Ruby and ADO to connect to and query an SQL Server database.

And "Using Ruby & SQL-DMO to Automate SQL Server Tasks" demonstrates how to use Ruby and SQL-DMO to automate server tasks.

Upvotes: 0

Related Questions