From: Arti Singh <arti.p.singh@...>
Date: 2009-05-07T00:04:23+09:00
Subject: Help with connecting to SQL Server 2005 Database  with Ruby

I am quite new to ruby and trying to connect to a SQL Server 2005
Database with ruby  to run a few queries but I am not getting anywhere.
Am I missing something? I am getting a connection refused on all counts.

I have installed the following gems: DBI,WIN32OLE,SEQUEL

Below are some of the strings that I have tried to use

db=Sequel.connect(database=@dbase,  user=@user, pword=@pword,
hostdb=@dbase)

db = Sequel.connect('postgres://username:password@hostdb/database')

db=DBI.connect("DBI:ADO:Provider=SQLNCLI;Data Source=hostdb;Initial
Catalog=dbase;username=username;pword=password")


db=DBI.connect("DBI:ODBC:Driver={SQLServer};Server=hostdb;Database=dbase;Uid=username;Pwd=password")

db=DBI.connect('DBI:ODBC:hostdb',Database=@dbase,Data
Source=@hostdb,Uid=@user,Pwd=@pword)

db=DBI.connect("DBI:OLEDB:Provider=sqloledb;Data Source=@dbase;Initial
Catalog=@dbase;User Id=@user;Password=@pword")
-- 
Posted via http://www.ruby-forum.com/.