From: Paul Tozer Date: 2007-08-04T00:26:09+09:00 Subject: Re: Connection String to MS SQL Server 2005 Felix Windt wrote: >> Vani >> up the ODBC >> > Server = PRODSK0322 >> Posted via http://www.ruby-forum.com/. >> > > Try http://support.microsoft.com/kb/305599 > > That might help creating the DSN you refer to in "DBI:ODBC:DSN". Not sure whether this is acceptable for posting , but there is a site I found which had a good snippet for connecting to SQL Server if you are on a windows machine. It uses ADO and worked first go. there are also other useful SQL Server snippets http://snippets.dzone.com/posts/show/3906 -- Posted via http://www.ruby-forum.com/.