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.