2007-06-20

求助！连接SQL Server出错

我按《应用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，重装之前是可以连上的。

希望能得到高手的指点，谢谢！
评论
bernieyoo 2007-06-20
问题已经解决。
我把database.yml文件用ultraedit打开后再编辑好就没有问题了。
看来是在windows下用netbeans直接编辑database.yml文件会存在编码的问题。
bernieyoo 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不匹配？
郁闷。。。。
bernieyoo
搜索本博客
博客分类
最近加入圈子
存档
最新评论