Sql Server 2005

J

johnhoge

I'm trying to follow the "rolling with ruby on rails"
(http://shrinkster.com/hrp) tutorial, but want to get it working with
SQL server express instead of mysql.

I did all of the recommended steps I cound find:

I copied ado.rb to X:/ruby/lib/ruby/site_ruby/1.8/DBD/ADO/ADO.rb

I reworked by database.yml file to point to the new database:

development:
adapter: sqlserver
database: cookbook
host: DBI:ADO:provider=SQLOLEDB;Data
Source=localhost\sqlexpress;Initial Catalog=cookbook;integrated
security=sspi

I have rails 1.1 which I just installed today (8/27/06)

When I try to access a page that should connect to this database, I get
an exeption with the following (abbreviated) stack trace that suggests
that mysql.rb is being used instead of ado.rb

Any help would be greatly appreciated.

John

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/vendor/mysql.rb:108:in
`initialize'
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/vendor/mysql.rb:108:in
`real_connect'
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mysql_adapter.rb:330:in
`connect'
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mysql_adapter.rb:87:in
`initialize'
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mysql_adapter.rb:36:in
`mysql_connection'
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:251:in
`connection_without_query_cache='
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/query_cache.rb:54:in
`connection='
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,482
Members
44,901
Latest member
Noble71S45

Latest Threads

Top