My company is developing an application for a customer. The customer have an ASP.NET web site and SQL Server 2008 database. The client wants to keep SQL Server 2008 database and he is complaining that ActiveRecord does not communicate natively with SQL Server 2008. They are asking us why ActiveRecord uses freeTDS in conjunction with unixODBC. Actually I googled it a little bit and in fact, I wasn''t able to find any library using only freeTDS to connect to SQL Server neither why there are only libs using freeTDS + unixOBC. Does anyone have any idea? Thanks in advance. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
My company is developing an application for a client. The client has an ASP.NET web site and SQL Server 2008 database and wants to keep it He is complaining that ActiveRecord does not communicate natively with SQL Server 2008 and are asking us why ActiveRecord uses freeTDS in conjunction with unixODBC. I googled it a little bit and to be hones, I wasn''t able to find any library using only freeTDS to connect to SQL Server neither why there are only libs using freeTDS + unixOBC. Any ideas? Thanks in advance. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
We are developing a solution for a client. Today he is using ASP.NET with SQL Server 2008 and wanna use SQL Server 2008 as database for the Rails application as well. So, they were asking us why Active Record uses unixODBC to communicate with SQL Server instead of using only freeTDS - they were concerned about performance problems. We googled the subject a little bit, and we weren''t able to find any Ruby solution that uses solely freeTDS. They all used unixODBC in some sort of way. Questions: 1) Why the freeTDS solutions out there always uses unixODBC in some sort of way? 2) Is it possible to communicate with SQL Server using only freeTDS? 3) Will we gain any performance using only freeTDS instead of freeTDS + unixODBC Thanks in advance. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
I used SQL Server 2005 for 18 months for a rails application. I recall having to use both freetds and unixodbc to get the connection to work. I''m a little hazy on this, but I think one is a higher level communication protocol, and one is a lower level communication protocol. Google the rest if it helps On Wed, Apr 28, 2010 at 4:08 PM, rhossi <felipecpg-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> We are developing a solution for a client. Today he is using ASP.NET > with SQL Server 2008 and wanna use SQL Server 2008 as database for the > Rails application as well. > > So, they were asking us why Active Record uses unixODBC to communicate > with SQL Server instead of using only freeTDS - they were concerned > about performance problems. > > We googled the subject a little bit, and we weren''t able to find any > Ruby solution that uses solely freeTDS. They all used unixODBC in some > sort of way. > > Questions: > > 1) Why the freeTDS solutions out there always uses unixODBC in some > sort of way? > 2) Is it possible to communicate with SQL Server using only freeTDS? > 3) Will we gain any performance using only freeTDS instead of freeTDS > + unixODBC > > Thanks in advance. > > -- > You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en. > >-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.