From: Mark Hahn Date: 2001-12-04T07:27:25+09:00 Subject: [ruby-talk:27382] Re: Ruby & MS-SQL7 I used DBI and ODBC with Ruby to MSSQL7 in a project and it worked just fine. -----Original Message----- From: Darrin Thompson [mailto:dthompson@characterlink.net] Sent: Monday, December 03, 2001 10:47 AM To: ruby-talk ML Subject: [ruby-talk:27361] Re: Ruby & MS-SQL7 Are you connecting from Linux or Windows. I know a reliable way to get to MSSQL7 from Linux that is free but too complicated to describe here. From Windows I think our company uses DBI and the ODBC driver. The ADO driver didn't work for us. Darrin Armin Roehrl wrote: >On Friday 30 November 2001 23:59, you wrote: > >>Armin Roehrl wrote: >> >>>Hi, >>> >>>Does anybody have any experience using Ruby & MS-SQL7. >>> >>>If possible I'd use ruby-DBI, as the coding is done with MySQL >>>and then at the customer's site that plane has to fly with MS-SQL7. >>>Am I right that the only way to get that plane off the ground is using >>>DBI with ODBC? >>> >>In Ruby/DBI 0.0.4 there was a Sybase (FreeTDS - works with MS-SQL) driver >>for Ruby/DBI but it there was no further development on it. >> >>If there would be a FreeTDS library for Ruby, I could write a DBD for >>it, but I guess there isn't. >> >>But what's wrong with ODBC? >> >I'll try with ODBC. Thanks, > Armin > >>Regards, >> >> Michael >> >