Connecting to MS SQL Server 2000

Ruby
1

I need to be able to querry the database on a Microsoft SQL Server 2000
from my Ruby script.

My only experience has been to connect to a MySQL database and I’m
hoping that someone from this august forum might be able to point me in
the right direction?

thanks

jack

2

This may help. Its for 2005, though:

https://www.ruby-forum.com/topic/125915

On Fri, Jun 12, 2009 at 3:47 PM, jackster the
jackle[email protected] wrote:

–
Posted via http://www.ruby-forum.com/.

–
Rilindo F.
AOL Instant Messenger: rilindo
Google Talk: [email protected]
Web S.: http://www.monzell.com
Primary: [email protected]
Secondary: [email protected]
"Rich bachelors should be heavily taxed. It is not fair that some men
should be happier than others. – Oscar Wilde

3

On Fri, Jun 12, 2009 at 12:47 PM, jackster the jackle <
[email protected]> wrote:

–
Posted via http://www.ruby-forum.com/.

I have had good luck with the ODBC bindings here
ODBC Binding for Ruby. The hardest part would be getting
FreeTDS
setup and configured. Are you connecting from a non-Windows box to the
SQL
Server?

Scott

4

Yes, I’m running my Ruby script from a Linux box.

thanks alot

jack

Scott Lillibridge wrote:

On Fri, Jun 12, 2009 at 12:47 PM, jackster the jackle <
[email protected]> wrote:

–
Posted via http://www.ruby-forum.com/.

I have had good luck with the ODBC bindings here
ODBC Binding for Ruby. The hardest part would be getting
FreeTDS
setup and configured. Are you connecting from a non-Windows box to the
SQL
Server?

Scott

5

jackster the jackle wrote:

I need to be able to querry the database on a Microsoft SQL Server 2000
from my Ruby script.

My only experience has been to connect to a MySQL database and I’m
hoping that someone from this august forum might be able to point me in
the right direction?

thanks

jack

I frequently use win32ole and ADO to query SQL Server 2000 databases
from a Windows machine.

That won’t help you if you’re on a non-Windows box.

David