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

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs