Problem Connecting to MS SQL Server 2005

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
(http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServer):

  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

On Jan 22, 2008 9:45 AM, Carlos O.
[email protected]
wrote:

username: sa
password: password1

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