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”)