Problem connecting with an SQL Server 2000 database


#1

Hi,

Iâ??m working on a rails application that uses data from an existing ms
sqlserver 2000 database.

Unfortunately I canâ??t get the connection to work properly.

I used
http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServer
to make the connection.

  • Inserted the ado.rb
  • Changed my database.yml to
    development:
    adapter: sqlserver
    database: database_name
    host: DBI:ADO:Provider=SQLOLEDB;Data Source=server_name;Initial
    Catalog=database_name;User Id=user_name;Password=your_pw_here;
    username: user_name
    password: your_pw_here

But I keep getting the following error message:

Open
OLE error code:800A0E7A in ADODB.Connection
Provider cannot be found. It may not be properly installed.
HRESULT error code:0x80020009
Exception occurred.

Anyone that has/had the same problem? Sollutions? Tips?

Many thanks!

Steven.