Rails - Jul 2009 - Rails apps. with Microsoft Access as a back end?

Curious as to whether anyone out there has set up Rails as a front end
to a M$ Access DB?

I have done it with SQL Server, and have used ODBC to do it, so I know
that this is certainly possible.

I''m interested in gotchas, and good advice.

I''m not interested in hearing questions about why someone would want to
do such a silly thing ;).

Thanks,
Wes
-- 
Posted via http://www.ruby-forum.com/.

Hi Wes,

On Wed, 2009-07-08 at 18:13 +0200, Wes Gamble wrote:
> I''m not interested in hearing questions about why someone would
want to
> do such a silly thing ;).
Understood.  Just wanted to send my sympathies ;-)

Best regards,
Bill

Never tried it.  I think the lack of an adapter is what kills this. 
I''d be curious to hear whether the sqlserver adapter in ODBC mode could
be fooled into hitting msaccess w/the right connect string...

-----Original Message-----
From: rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
[mailto:rubyonrails-talk@googlegroups.com] On Behalf Of Wes Gamble
Sent: Wednesday, July 08, 2009 9:13 AM
To: rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
Subject: [Rails] Rails apps. with Microsoft Access as a back end?


Curious as to whether anyone out there has set up Rails as a front end to a M$
Access DB?

I have done it with SQL Server, and have used ODBC to do it, so I know that this
is certainly possible.

I''m interested in gotchas, and good advice.

I''m not interested in hearing questions about why someone would want to
do such a silly thing ;).

Thanks,
Wes
--
Posted via http://www.ruby-forum.com/.



GHC Confidentiality Statement

This message and any attached files might contain confidential information
protected by federal and state law. The information is intended only for the use
of the individual(s) or entities originally named as addressees. The improper
disclosure of such information may be subject to civil or criminal penalties. If
this message reached you in error, please contact the sender and destroy this
message. Disclosing, copying, forwarding, or distributing the information by
unauthorized individuals or entities is strictly prohibited by law.

Roy Pardee wrote:
> Never tried it.  I think the lack of an adapter is what kills this. 
I''d
> be curious to hear whether the sqlserver adapter in ODBC mode could be 
> fooled into hitting msaccess w/the right connect string...
Good point.  Might be that the connect string setup would have to be 
overwritten,  but I''m assuming the SQL conversation should work fine.

WG
-- 
Posted via http://www.ruby-forum.com/.