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

Hi Wes,

On Wed, 2009-07-08 at 18:13 +0200, Wes G. 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 :wink:

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…

Roy P. 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

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs