[Rails] Re: SQL Server via DBI/ODBC configuration

2009-05-05 Thread Murray Steele
There's a rails-sqlserver google group: http://groups.google.com/group/rails-sqlserver-adapter. You could try asking your question there as the group is more focussed to your setup. >From what I recall I think that this problem is related to ruby DBI & ruby odbc version clashes. Cheers, Murray

[Rails] Re: SQL Server via DBI/ODBC configuration

2009-05-05 Thread Rob
Mike, Did you have any luck with this? Whats described by Harold seems to match everyone elses experience. By any chance would you be on a server for which you don't have root access? I have no troubles with freetds and iodbc getting to the SQL Server that I'm intending to use, but I cannot ge

[Rails] Re: SQL Server via DBI/ODBC configuration

2009-05-05 Thread Rob
mvargo: Did you have any luck with this? I can get freetds and iodbc to connect successfully but ruby-odbc just doesn't seem to support a shared (non-root access) linux installation like everything else. I'm blocked as make install tries to put the files in the standard locations and to make th

[Rails] Re: SQL Server via DBI/ODBC configuration

2009-04-15 Thread Harold
Mike, in my experience this has been painful. Here's a few things to look for: First, make sure that TDS is set up fine. Verify it with this command: tsql -S server -U user -P password Make sure you have ruby-odbc to have ruby load the ODBC driver (think this could potentially solve your issue).

[Rails] Re: SQL Server via DBI/ODBC configuration

2009-04-14 Thread mvargo
Dear Chris, Thank you for reponding. I tried that. I get the same error from a different stack. It finds the new sqlserver.rb from the gem you suggested. But it still barfs in DBI because it can't find the ODBC driver. I wonder if it's some kind of path thing for finding the dbd- odbc thing.

[Rails] Re: SQL Server via DBI/ODBC configuration

2009-04-14 Thread Chris Johnson
Try this gem out, works for me I think your on the right path... http://github.com/rails-sqlserver/2000-2005-adapter/tree/master On Tue, Apr 14, 2009 at 12:29 PM, mvargo wrote: > > I have followed the cookbook on > http://wiki.rubyonrails.org/database-support/ms-sql > but am having problems with