论坛首页 入门讨论版 rails

求助!连接SQL Server出错

浏览 1331 次
该帖已经被评为新手帖
作者 正文
最后更新时间:2007-06-20
我按《应用Rails进行敏捷WEB开发》中depot的开发步骤操作,由于我机器上已经安装了SQLServer,就没有用MYSQL。按照网上找到的资料进行了设置,可是在连接SQL Server数据库时却出现了错误。
错误内容如下:
C:/ruby/lib/ruby/1.8/yaml.rb:133:in `load': syntax error on line 2, col 0: `database:depot_development' (ArgumentError)

        from C:/ruby/lib/ruby/1.8/yaml.rb:133:in `load'

        from C:/ruby/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/initializer.rb:523:in `database_configuration'

        from C:/ruby/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/initializer.rb:228:in `initialize_database'

        from C:/ruby/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/initializer.rb:88:in `process'

        from C:/ruby/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/initializer.rb:43:in `send'

        from C:/ruby/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/initializer.rb:43:in `run'

        from ./script/../config/../config/environment.rb:14

        from C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require'

        from C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require'

        from C:/ruby/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/commands/generate.rb:1

        from C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require'

        from C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require'

        from script/generate:3



我的开发环境如下:
Windows XP SP2
NetBeans Ruby IDE 070620
Ruby 1.8.6
Rails 1.2.3
SQL Server 2000 SP4

我按网上资料下载了Ruby-DBI最新的0.1.1,将其下的lib\dbd\ADO.rb复制到C:\ruby\lib\ruby\site_ruby\1.8\DBD\ADO下,在environment.rb中添加了
require 'win32ole' 
WIN32OLE.codepage = WIN32OLE::CP_UTF8


database.yml内容如下:
development:
adapter:sqlserver
database:depot_development
host:127.0.0.1
username:sa
password:sa

test:
adapter:sqlserver
database:depot_development
host:127.0.0.1
username:sa
password:sa

production:
adapter:sqlserver
database:depot_development
host:127.0.0.1
username:sa
password:sa


连接数据库时报了上面的错误。
我是刚重装了Windows和ROR,重装之前是可以连上的。

希望能得到高手的指点,谢谢!
   
最后更新时间:2007-06-20
修改database.yml,在每行前加空格后,出错提示变成:
C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract/connection_specification.rb:204:in `establish_connection': adapter:sqlserver database:depot_development host:127.0.0.1 username:sa password:sa database is not configured (ActiveRecord::AdapterNot Specified)

        from C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract/connection_specification.rb:202:in `establish_connection'

        from C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract/connection_specification.rb:195:in `establish_connection'

        from C:/ruby/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/initializer.rb:229:in `initialize_database'

        from C:/ruby/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/initializer.rb:88:in `process'

        from C:/ruby/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/initializer.rb:43:in `send'

        from C:/ruby/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/initializer.rb:43:in `run'

        from ./script/../config/../config/environment.rb:15

        from C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require'

        from C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require'

        from C:/ruby/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/commands/generate.rb:1

        from C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require'

        from C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require'
        from script/generate:3


像是Adapter不匹配?
郁闷。。。。
   
0 请登录后投票
最后更新时间:2007-06-20
问题已经解决。
我把database.yml文件用ultraedit打开后再编辑好就没有问题了。
看来是在windows下用netbeans直接编辑database.yml文件会存在编码的问题。
   
0 请登录后投票
论坛首页 入门讨论版 rails

跳转论坛:
JavaEye推荐