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

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
Steven D. (Guest)
on 2006-03-28 14:30
(Received via mailing list)
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/HowtoConne...
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.
This topic is locked and can not be replied to.