浏览 1331 次
|
锁定老贴子 主题:求助!连接SQL Server出错
该帖已经被评为新手帖
|
|
|---|---|
| 作者 | 正文 |
|
最后更新时间: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,重装之前是可以连上的。 希望能得到高手的指点,谢谢! 声明:JavaEye文章版权属于作者,受法律保护。没有作者书面许可不得转载。
|
|
| 返回顶楼 | |
|
最后更新时间: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不匹配? 郁闷。。。。 |
|
| 返回顶楼 | |
|
最后更新时间:2007-06-20
问题已经解决。
我把database.yml文件用ultraedit打开后再编辑好就没有问题了。 看来是在windows下用netbeans直接编辑database.yml文件会存在编码的问题。 |
|
| 返回顶楼 | |


