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.
on 2006-03-28 12:30