Marnen Laibow-Koser wrote in post #959078: > 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.
I have tried both with an User DSN and a File DSN, and the User DSN used the login on the system. > > 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. Can I use TinyTds on a Windowsbox? I thought it was Linux-only. Magnus -- 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.
