Magnus D. wrote in post #958933: > Marnen Laibow-Koser wrote in post #958814: >> Magnus D. wrote in post #958686: >>> I'm trying to connect to a SQLServer 2008 database running on localhost, >>> but I can't seem to get it working. >> >> Advice: do not use MS SQL Server with Rails. Do not do Rails >> development on Windows. Both of these will make your life harder. >> > I'm starting to learn this. :) > >> >> What does your database.yml file look like? >> > > > development: > adapter: sqlserver > mode: odbc > dsn: dsn_name > database: database_name > > > I have a user dsn connected to the database.
You neglected to specify user and password. Also, you're using ODBC. I would recommend instead installing TinyTds and using mode: dblib. This allows Rails to make a direct TDS connection to your DB and bypass ODBC entirely. > > > Thanks > Magnus Best, -- Marnen Laibow-Koser http://www.marnen.org [email protected] Sent from my iPhone -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
