I did everything you noted below. I think I had already installed
ironruby-sqlserber, which is why I didn't notice the adapter. In
answer to Ivan, I created my database but forgot to check the logs.
It's been awhile since I used Rails and had db issues. :) Sadly, the
log just tells me what trace tells me, which isn't too surprising.
I have had problems with connection timeouts on this machine in the
past, but that was generally noticable in SSMS as well. I'll try on
another machine and see where I land.
Thanks for the help!
Ryan
Sent from my iPhone
On Jan 20, 2010, at 3:24 AM, Jimmy Schementi <jimmy.scheme...@microsoft.com
> wrote:
ironruby-sqlserver simple depends on ironruby-dbi, which replaces
the built-in DBI module with one capable of working with ADO.NET, as
well as activerecord-sqlserver-adapter. It also patches activerecord-
sqlserver-adapter to allow connection through ADO.NET. So doing a
gem install ironruby-sqlserver pulls down those two gems also, and
wires everything up:
> igem install ironruby-sqlserver --no-rdoc --no-ri
Successfully installed ironruby-dbi-0.1.0
Successfully installed activerecord-sqlserver-adapter-2.3.0
Successfully installed ironruby-sqlserver-0.1.0
3 gems installed
In fact, your log below shows activerecord-sqlserver-adapter on the
stack =)
For the connection issue, did you set your database.yml? As long as
ir.exe is running as you, integrated security should be fine. From
looking at your log, this should work (if you’re using sqlexpress, a
nd you set up the database to use Windows authentication):
development:
mode: ADONET
adapter: sqlserver
host: CATAPULT\SQLEXPRESS
database: ironruby_on_rails_dev
integrated_security: true
Otherwise, you can set up a specific username and password for your
database, and then specific the “username” and “password” in
the database yml file.
~Jimmy
From: ironruby-core-boun...@rubyforge.org [mailto:ironruby-core-
boun...@rubyforge.org] On Behalf Of Ryan Riley
Sent: Tuesday, January 19, 2010 8:46 PM
To: ironruby-core@rubyforge.org
Subject: Re: [Ironruby-core] Updated Rails instructions
I just noticed the instructions are using ironruby-sqlserver though
you note in your email that you are supporting activerecord-
sqlserver-adapter. Is ironruby-sqlserver a wrapper, or would you
just need to swap your adapter?
I'm also running into other problems:
1) I verified that I have the correct access (unless rails needs
access?), but irake db:migrate produces the following error:
<image001.png>
<image002.png>
2) Trying to open the environment settings from the default page for
the Rails app produces this message:
<image003.png>
Any help is appreciated. I'm stumped. And if anyone knows how to
copy text from Console2, I would appreciate the tip.
Thanks!
Ryan Riley
Email: ryan.ri...@panesofglass.org
LinkedIn: http://www.linkedin.com/in/ryanriley
Blog: http://wizardsofsmart.net/
Twitter: @panesofglass
Website: http://panesofglass.org/
On Thu, Jan 14, 2010 at 6:48 PM, Jimmy Schementi <jimmy.scheme...@microsoft.com
> wrote:
All,
http://ironruby.net/Documentation/Rails has been updated to show
instructions for running Rails 2.3.5 on IronRuby, including using
the official activerecord-sqlserver-adapter (v2.3). Thanks to Ivan
for his work on ironruby-dbi!
The steps are extrememly simple now. Assuming you have IronRuby
installed and a Rails app you'd like to run on IronRuby:
1. Install Rake, Rails, and IronRuby SQLServer
igem install rake rails ironruby-sqlserver
2. Add the following to the top of your app's config/environment.rb:
require 'rubygems'
require 'ironruby_sqlserver'
3. Connect to SQLServer in config/database.yml:
development:
mode: ADONET
adapter: sqlserver
host: YOURMACHINENAME\SQLEXPRESS
database: app123_development
integrated_security: true
4. Migrate the database and start the server:
irake db:migrate
ir script\server
And that's it! The documentation link above also has a walk through
setting up IronRuby, Rails, and SQLServer, and shows a basic Rails
"scaffold" running.
Coming soon are updated instructions for running rack-based web
applications in IIS on IronRuby.
Let me know if you have any questions,
~Jimmy
_______________________________________________
Ironruby-core mailing list
Ironruby-core@rubyforge.org
http://rubyforge.org/mailman/listinfo/ironruby-core
_______________________________________________
Ironruby-core mailing list
Ironruby-core@rubyforge.org
http://rubyforge.org/mailman/listinfo/ironruby-core
_______________________________________________
Ironruby-core mailing list
Ironruby-core@rubyforge.org
http://rubyforge.org/mailman/listinfo/ironruby-core
