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):
-
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 -
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