Connecting to MS SQL Server 2000

ruby-talk
1

I need to be able to querry the database on a Microsoft SQL Server 2000

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

···

from my Ruby script.
--
Posted via http://www.ruby-forum.com/.

2

This may help. Its for 2005, though:

···

On Fri, Jun 12, 2009 at 3:47 PM, jackster the jackle<johnsheahan@sflistdb.com> 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
--
Posted via http://www.ruby-forum.com/\.

--
Rilindo Foster
AOL Instant Messenger: rilindo
Google Talk: rilindo@gmail.com
Web Site: http://www.monzell.com
Primary: rilindo@me.com
Secondary: rilindo@gmail.com
"Rich bachelors should be heavily taxed. It is not fair that some men
should be happier than others. -- Oscar Wilde

3

I have had good luck with the ODBC bindings here
http://www.ch-werner.de/rubyodbc/\. The hardest part would be getting FreeTDS
setup and configured. Are you connecting from a non-Windows box to the SQL
Server?

Scott

···

On Fri, Jun 12, 2009 at 12:47 PM, jackster the jackle < johnsheahan@sflistdb.com> 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
--
Posted via http://www.ruby-forum.com/\.

4

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

···

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

5

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 < > johnsheahan@sflistdb.com> wrote:

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

I have had good luck with the ODBC bindings here
http://www.ch-werner.de/rubyodbc/\. The hardest part would be getting
FreeTDS
setup and configured. Are you connecting from a non-Windows box to the
SQL
Server?

Scott

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