> Since you use MSSQL all the time perhaps you could answer my next > hurdle. How do I convert my connection into a dsn? My connection > string is: > jdbc:jtds:sqlserver://rogue:1433/AALite;
Hi there, This is a list I use when setting up a new MSSQL based application. You might need to skip/change some of the steps. I hope it helps: 1. Install Ruby (1.8.6): http://www.ruby-lang.org/en/downloads/ 2. Install rubygems: a. http://rubygems.org/pages/download (zip version) b. Unpack to a directory and cd there c. ruby setup.rb 3. Install rails: gem install rails –v=2.3.5 4. Install mongrel: gem install mongrel 5. Install mongrel service: gem install mongrel_service 6. Install SQL Server adapter: gem install activerecord-sqlserver- adapter 7. Install ODBC gem: gem install odbc-rails 9. Install SQL Server Management utility (from Microsoft) 10. Create SQL Server DB (name <your_name_here>) 11. Create login in SQL Server (<your_name_here> For simplicity I use the same name as DB) 12. Create DB user (<your_name_here>) 13. Create DSN in Windows: a. Control Panel -> Adminstrative Tasks -> Data Sources (ODBC) b. Click on System DSN -> Add c. Select type SQL Server i. Name: <your_name_here> For simplicity I use the same name as the DB ii. Description: <your_description_here> iii. Server: Server name (<value_from_SQL_Server_Management> Something like XXXXXXXXXX\SQLEXPRESS) iv. Use SQL Authentication Then in your database.yml something like this: development: adapter: sqlserver mode: odbc dsn: <your_dsn_name_here> username: <your_db_user_here> password: <your_db_password_here> # host: not required when DSN is used I read in a post a few days ago that if you use DSN you don't even need username and password. I have not tried that so I can't say for sure. Good luck. -- 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.
