Problem connecting with an SQL Server 2000 database


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 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