Can anyone tell me if it is possible to connect to Microsoft Access db and how? I have several systems that use Access and I need to create new front end functionality to the Access tables. Thanks --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Hey Lewis, I''ve never done that but I''m wondering if ODBC or ADO aren''t your friends here. I believe there are examples flying around for both ODBC and ADO connections. Try that and let us know how you get on. Cheers, Mel On 5/17/07, Lewis <lhurley-AHdNnX9Xs3pCcHz8LpDsnNi2O/JbrIOy@public.gmane.org> wrote:> > > Can anyone tell me if it is possible to connect to Microsoft Access db > and how? I have several systems that use Access and I need to create > new front end functionality to the Access tables. > > Thanks > > > > >--~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
On 17-May-07, at 11:01 AM, Mel Riffe wrote:> Hey Lewis, > > I''ve never done that but I''m wondering if ODBC or ADO aren''t your > friends here. > > I believe there are examples flying around for both ODBC and ADO > connections. > > Try that and let us know how you get on. > > Cheers, > Mel > > > On 5/17/07, Lewis <lhurley-AHdNnX9Xs3pCcHz8LpDsnNi2O/JbrIOy@public.gmane.org> wrote: > > Can anyone tell me if it is possible to connect to Microsoft Access db > and how? I have several systems that use Access and I need to create > new front end functionality to the Access tables. > > ThanksI will be going down that path shortly and have these bookmarked: http://ruby-dbi.rubyforge.org/ http://groups.google.com/group/comp.lang.ruby/browse_thread/thread/ ce3a7a464e3f37c/aac2e8db2b89a8f5%23aac2e8db2b89a8f5 http://www.troubleshooters.com/codecorn/ruby/database/index.htm If you discover anything useful, I''d appreciate you post back. Cheers, Jodi General Partner The nNovation Group inc. www.nnovation.ca/blog  --~--~---------~--~----~------------~-------~--~----~ 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?hl=en -~----------~----~----~----~------~----~------~--~---
Are you able to use the SQL Server upsize wizard (not sure if that''s the exact name - the thing that converts Access DBs to SQL Server), then use e.g. the free SQL Server engine? Your data would remain intact, but you''d then be using SQL Server which is far more scalable/robust than Access. It''s probably a lot easier to find help for Rails/SQL Server than for Rails/Access... BTW, I suggested using the free version of SQL Server, which supports a limited number of users and database size, because I assume this would meet your requirements if you''re starting from Access to begin with; if not, just use one of the for-pay SQL Server versions. From Rails'' perspective, it shouldn''t care which version of SQL Server you use. Regards Dave M. On 18/05/07, Lewis <lhurley-AHdNnX9Xs3pCcHz8LpDsnNi2O/JbrIOy@public.gmane.org> wrote:> > Can anyone tell me if it is possible to connect to Microsoft Access db > and how? I have several systems that use Access and I need to create > new front end functionality to the Access tables. > > Thanks > > > > >--~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---