Forum: Ruby on Rails Problem connecting with an SQL Server 2000 database

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
Steven D. (Guest)
on 2006-03-28 14:30
(Received via mailing list)

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
to make the connection.

- Inserted the ado.rb
- Changed my database.yml to
  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:

    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!

This topic is locked and can not be replied to.