[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

Help with connecting to SQL Server 2005 Database with Ruby

Arti Singh

5/6/2009 3:04:00 PM

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-....
2 Answers

Ben Lovell

5/6/2009 3:19:00 PM

0

[Note: parts of this message were removed to make it a legal post.]

On Wed, May 6, 2009 at 4:04 PM, Arti Singh <arti.p.singh@gmail.com> wrote:

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

Try this if you're using sequel:

DB = Sequel.ado('database_name', :host => 'localhost', :user => 'username',
:password => 'password')

Should work if you replace the 'database_name', host, user and password with
your own.

Ben

Arti Singh

5/6/2009 4:12:00 PM

0

Thank you Ben. This works now.
--
Posted via http://www.ruby-....