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.?

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

Re: [Rails] Does Rails work with SQL2005 express?
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.

The Rails app will be on the same server as the SQL2005 Express
database. I’m used to using SS2000 with the Management Console tools.
SQL2005Express doesn’t have that. I’m assuming that I could use
migrations to build the tables. I don’t know enough about 2005Express
to know whether it will work with the current adapter, or not. I was
hoping someone had some current experience with it.

-Larry

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 Kelly ldk2005@gmail.com
Reply-To: rubyonrails-talk@googlegroups.com
Date: Fri, 15 Sep 2006 12:40:32 -0700
To: rubyonrails-talk@googlegroups.com
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

Best Regards,
-Larry
“Work, work, work…there is no satisfactory alternative.”

        --- E.Taft Benson

The Rails app will be on the same server as the SQL2005 Express database. I’m used to using SS2000 with the Management Console tools. SQL2005Express doesn’t have that. I’m assuming that I could use migrations to build the tables. I don’t know enough about 2005Express to know whether it will work with the current adapter, or not. I was hoping someone had some current experience with it.