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: development: adapter: sqlserver database: database_name host: DBI:ADO:Provider=SQLOLEDB;Data Source=localhost,1692 username: user_name password: your_pw_here Platform: Windows XP Professional Rails 1.8.2 DBI 0.2 ADO 0.1 -- Posted via http://www.ruby-forum.com/.
On 3/13/06, Wes Gamble <weyus@att.net> wrote:> 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 HOWTOYes, you need to download/install this properly, but once done, the above works just fine for me, but this is assuming one is not using a named instance or Windows security.
Wes Gamble
2006-Mar-14 00:59 UTC
[Rails] Re: Connectivity to Microsoft SQL Server using ADO
I am not using Windows authentication, but it is a named instance. Do you know why the named instance would matter? Wes Corey Lawson wrote:> On 3/13/06, Wes Gamble <weyus@att.net> wrote: >> 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 > > Yes, you need to download/install this properly, but once done, the > above works just fine for me, but this is assuming one is not using a > named instance or Windows security.-- Posted via http://www.ruby-forum.com/.