Does Rails work with SQL2005 express?

Rails
1

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

2

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

3

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 K. [email protected]
Reply-To: [email protected]
Date: Fri, 15 Sep 2006 12:40:32 -0700
To: [email protected]
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