How to connect to SQL Server 2005 database through Ruby

Question

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

the Tin Man · Accepted Answer · 2012-12-04 15:18:54Z

1

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.

edited Dec 4, 2012 at 15:18

answered Dec 4, 2012 at 15:10

the Tin Man

161k44 gold badges222 silver badges308 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

the Tin Man · Accepted Answer · 2012-12-04 15:06:54Z

0

"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.

edited Dec 4, 2012 at 15:06

the Tin Man

161k44 gold badges222 silver badges308 bronze badges

answered Jan 9, 2010 at 16:45

David Mullet

4362 silver badges4 bronze badges

Collectives™ on Stack Overflow

How to connect to SQL Server 2005 database through Ruby

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related