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
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
On Jan 22, 2008 9:45 AM, Carlos Ortega <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> > 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: password1I 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 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---