Problem Connecting to MS SQL Server 2005

rubyonrails-talk
1

Hello Friends:

I would appreciate a lot your help on the following situation.

I'm trying to connect to MS SQL Server 2005 but I'm getting the following error while trying to execute a scaffold command:

C:\ruby\RoR1.2.6\rails\work\demoPba0>ruby script\generate scaffold receta receta

      exists app/controllers/       exists app/helpers/       exists app/views/receta       exists app/views/layouts/       exists test/functional/   dependency model       exists app/models/       exists test/unit/       exists test/fixtures/    identical app/models/receta.rb    identical test/unit/receta_test.rb    identical test/fixtures/recetas.yml Open     OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server       [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.     HRESULT error code:0x80020009       Exception occurred.

I tried to follow step by step the instructions that appears in the HowtoConnectToMicrsoftSQLServer article (Peak Obsession):

1) I got and unpack the last DBI from http://rubyforge.org/projects/ruby-dbi/ and I copied this file to my path c:/ruby/lib/ruby/site_ruby/1.8/DBD/ADO/ADO.rb

2) I modified my .yml file demoPba0/config/database.yml # => demoPba0 is the name of my app # => demoPba0_development is the name of the DB

development:   adapter: sqlserver   database: demoPba0_development   host: DBI:ADO:Provider=SQLOLEDB;Data Source=(local);Initial Catalog=demoPba0_development;User Id=sa;Password=password1;   username: sa   password: password1

but the final result still is the same

My environment is: Windows XP SP2, Ruby 1.8.26, RoR 1.2.6, MS SQL Server Enterprise 2005 All my environment is local.

Thanks in advance

2

I haven’t connected to a SQL Server 2005 database in awhile, but two things jump out at me. First, you don’t need to specify the username and password twice, but I don’t know if it matters in which place you do specify it. Second, replace (local) with localhost.

Let us know whether it works.

Regards, Craig