Displaying 2 results from an estimated 2 matches for "your_pw_here".
2006 Mar 13
2
Connectivity to Microsoft SQL Server using ADO
Based on this page:
http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServer
using this specification
development:
adapter: sqlserver
database: database_name
host: server_name
username: user_name
password: your_pw_here
in database.yml for your SQL Server connection doesn''t work. Some
debugging code reveals that only the password comes through into
sqlserver_adapter.rb when you use it. I''m not sure why.
NOTE - you still have to copy the ADO.rb file per the HOWTO
However, this seems to work...
2006 Mar 28
8
Problem connecting with an SQL Server 2000 database
...om/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...