Request: Full description of mechanims required to intergrate current Ruby / Ruby on Rails with MS SQL Server 2005 Environment: * Ruby 1.8.6-25 (ruby 1.8.6 (2007-03-13 patchlevel 0) [i386-mswin32]) * Rails 1.2.3 * ruby-dbi 0.1.1 (installed dbi,dbd_ADO) * OS: Windows XP Professional sp4 * MS SQL Server Express 2005 installed on local machine Background: I have used various settings for the config.db to no avail. These have included (where sa / password ARE the credentials for the database referenced): development: adapter: sqlserver database: event_development username: sa password: password host: localhost mode: DBI:ADO provider: SQLNCLI development: adapter: sqlserver database: event_development username: sa password: password host: DBI:ADO:Provider=SQLNCLI;Data Source=localhost;Initial Catalog=event_development;User Id=sa;Password=Marimba; development: adapter: sqlserver database: event_development username: sa password: password host: localhost Any help will be appreciated. Regards -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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?hl=en -~----------~----~----~----~------~----~------~--~---
Craig Demyanovich
2007-Sep-26 02:25 UTC
Re: Ruby on Rails | MS SQL Server 2005 | Configuration
Since I no longer use Windows for my day job, I''m not sure if I have a good database.yml for SQL Server 2005 documented anywhere. However, I''ll have a look and get back to you. Craig On 9/25/07, Joe White <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> > > Request: Full description of mechanims required to intergrate current > Ruby / Ruby on Rails with MS SQL Server 2005 > > Environment: > * Ruby 1.8.6-25 > (ruby 1.8.6 (2007-03-13 patchlevel 0) [i386-mswin32]) > * Rails 1.2.3 > * ruby-dbi 0.1.1 (installed dbi,dbd_ADO) > * OS: Windows XP Professional sp4 > * MS SQL Server Express 2005 installed on local machine > > > Background: > I have used various settings for the config.db to no avail. These have > included (where sa / password ARE the credentials for the database > referenced): > > development: > adapter: sqlserver > database: event_development > username: sa > password: password > host: localhost > mode: DBI:ADO > provider: SQLNCLI > > development: > adapter: sqlserver > database: event_development > username: sa > password: password > host: DBI:ADO:Provider=SQLNCLI;Data Source=localhost;Initial > Catalog=event_development;User Id=sa;Password=Marimba; > > development: > adapter: sqlserver > database: event_development > username: sa > password: password > host: localhost > > Any help will be appreciated. > > Regards > -- > Posted via http://www.ruby-forum.com/. > > > >--~--~---------~--~----~------------~-------~--~----~ 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?hl=en -~----------~----~----~----~------~----~------~--~---