June 2009
Intermediate to advanced
60 pages
1h 15m
English
Content preview from Rails on WindowsBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Working with Microsoft SQL Server
If you've been doing any Microsoft development then you've most likely encountered Microsoft SQL Server. If you don't plan to use Microsoft SQL Server with your Rails projects, you can safely skip this section.
Rails has built-in support for this as long as your database design allows it. There are a few issues you should be aware of before starting:
SQL Server lets you name tables using mixed-case, dashes, and other strange characters. Rails simply can't handle those well, so if you can't rename your tables, you may have to get creative. Table and column names should be defined using lowercase letters and underscores.
Views work just like tables but you're limited when it comes to doing updates.
When you use Rake to migrate your database, created tables are owned by the user that you specify in database.yml, not by the database owner.
Stored procedures aren't easy to pull off but can be done provided you are careful in how you construct the return values from your procedure. I've had success executing procedures that return a single recordset.
There are two methods to connect your Rails applications to a Microsoft SQL Server database: an ODBC connection or an ADO connection.
I am going to assume that you have access to Microsoft SQL Server 2000 or higher and that you can already connect to that server using Enterprise Manager on your development machine. I also assume you've got a database created for your Rails application and that you've granted a user ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.