ruby connect to mssql from rails on windows

最新推荐文章于 2025-08-13 06:09:36 发布

原创最新推荐文章于 2025-08-13 06:09:36 发布 · 601 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#rails #ruby #deprecated #sqlserver #download #windows

ruby 专栏收录该内容

2 篇文章

订阅专栏

本文档详细介绍了如何在Ruby环境中安装必要的组件如Rake、ActiveSupport、ActiveRecord等，并从Rubyforge下载对应的gem文件。此外还提供了如何下载SQL Server适配器并将其放置在正确的位置以便 ActiveRecord 使用。最后，通过示例代码展示了如何使用DBI库连接到SQL Server数据库。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

download rake from http://rubyforge-files.ruby-forum.com/rake/rake-0.8.3.gem
gem install rake

or

gem install rake --source=http://rubyforge-files.ruby-forum.com/rake/rake-0.8.3.gem

download activesupport from http://files.rubyforge.mmmultiworks.com/activesupport/activesupport-2.1.2.gem
gem install activesupport

download acrivesupport from http://rubyforge-files.ruby-forum.com/activerecord/activerecord-2.1.2.gem
gem install activerecord

dowanload sqlserver_adapter.rb from http://svn.rubyonrails.org/rails/adapters/sqlserver/lib/active_record/connection_adapters/
copy to <rails_app_home>/lib/ruby/gems/1.8/gems/activerecord-*/lib/active_record/connection_adapters

download deprecated from http://rubyforge-files.ruby-forum.com/deprecated/deprecated-2.0.1.gem
gem install deprecated

download dbi from http://files.rubyforge.vm.bytemark.co.uk/ruby-dbi/dbi-0.4.0.gem
gem install dbi

download dbi from http://files.rubyforge.mmmultiworks.com/ruby-dbi/dbi-0.2.2.zip
copy dbi-0.2.2/lib/dbd/ADO.rb to X:/ruby/lib/ruby/site_ruby/1.8/DBD/ADO/

=====
环境配置好后，运行ConnectToMssql.rb
require "dbi"
dbh=DBI.connect('DBI:ADO:Provider=SQLOLEDB;Connect Timeout=5;Data Source=10.11.60.1;Initial Catalog=DG;Persist SecurityInfo=True;User ID=sa;Password=;')
sth=dbh.prepare('select * from PflUser')
sth.execute
while row=sth.fetch do
p row
end