Is anyone using MS SQL server 2005 Express with Rails? If so, would you mind sharing your experiences? Does it work with the ''standard'' SQLSERVER adapter? Are there any issues, tips, tricks, etc.? - Best Regards, -Larry "Work, work, work...there is no satisfactory alternative." --- E.Taft Benson --~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
Are you trying to run it on windows or linux? I haven''t been able to get it to work on a linux box, although I can connect to SQL Server 2000 from linux. Here are the two wiki links: http://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLServer http://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosoftSQLServerFromRailsOnLinux --~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
Is Express different in any way as far as interface goes? The real pain is setting up ODBC if you¹re not running your Rails app on a Windows server... But there is a lot of documentation out there use Google. From: Larry Kelly <ldk2005-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> Reply-To: <rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> Date: Fri, 15 Sep 2006 12:40:32 -0700 To: <rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> Subject: [Rails] Does Rails work with SQL2005 express? Is anyone using MS SQL server 2005 Express with Rails? If so, would you mind sharing your experiences? Does it work with the ''standard'' SQLSERVER adapter? Are there any issues, tips, tricks, etc.? - Best Regards, -Larry "Work, work, work...there is no satisfactory alternative." --- E.Taft Benson --~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
The Rails app will be on the same server as the SQL2005 Express database. I''m used to using SS2000 with the Management Console tools. SQL2005Express doesn''t have that. I''m assuming that I could use migrations to build the tables. I don''t know enough about 2005Express to know whether it will work with the current adapter, or not. I was hoping someone had some current experience with it. -Larry> > > On 9/15/06, HH <lists-HAWAbpnI61OZ1JSuHaJ1sQC/G2K4zDHf@public.gmane.org> wrote: > > > > Is Express different in any way as far as interface goes? > > > > The real pain is setting up ODBC if you''re not running your Rails app on > > a Windows server... But there is a lot of documentation out there – use > > Google. > > > > > > ------------------------------ > > *From: *Larry Kelly <ldk2005-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> > > *Reply-To: *<rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > > *Date: *Fri, 15 Sep 2006 12:40:32 -0700 > > *To: *<rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > > *Subject: *[Rails] Does Rails work with SQL2005 express? > > > > > > Is anyone using MS SQL server 2005 Express with Rails? If so, would you > > mind sharing your experiences? > > > > Does it work with the ''standard'' SQLSERVER adapter? > > > > Are there any issues, tips, tricks, etc.? > > > > > > - > > Best Regards, > > -Larry > > "Work, work, work...there is no satisfactory alternative." > > --- E.Taft Benson > > > > > > > > > > > > > > > -- > > Best Regards, > -Larry > "Work, work, work...there is no satisfactory alternative." > --- E.Taft Benson >The Rails app will be on the same server as the SQL2005 Express database. I''m used to using SS2000 with the Management Console tools. SQL2005Express doesn''t have that. I''m assuming that I could use migrations to build the tables. I don''t know enough about 2005Express to know whether it will work with the current adapter, or not. I was hoping someone had some current experience with it. -- Best Regards, -Larry "Work, work, work...there is no satisfactory alternative." --- E.Taft Benson --~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---