David Lee wrote:
> I am running Ruby on Fedora Core 6 and I am running into problems I do
> not see on my windows box.  Any help would be awesome - its been 2 days
> I tried everything and even installed unixODBC and that worked but
> installing freeTDS ha problems.  Can someone guide me into getting this
> to work?

I was able to install freetds on ubuntu 7.04. This is my /tmp/odbc.ini 
part.

[TESTSQL]
Driver          = FreeTDS
Description     = FreeTDS SQL Server ODBC driver
Server          = testsql.my.com
Port            = 1433
Database        = ruby
User            =
Password        =
Mars_Connection = No
Logging         = 0
LogFile         =
QuotedId        = Yes
AnsiNPW         = Yes
Language        =
Version7        = No
ClientLB        = No
Failover_Partner =
VarMaxAsLong     = No

And am using DBI odbc driver.

require 'dbi'
dbs = DBI.connect('DBI:ODBC:TESTSQL', 'usr', 'pwd')

It works with rails too, minus UTF-8 support. But that can be managed 
too.


by
TheR
-- 
Posted via http://www.ruby-forum.com/.