pepe wrote in post #960517: >> It didn't work for me: >> C:\Ruby187>gem install activerecord-sqlserver-adapter >> --source=http://gems.rubyonrails.org >> ERROR: Could not find a valid gem 'activerecord-sqlserver-adapter' (>= >> 0) in any repository > > Have you tried simply: > gem install activerecord-sqlserver-adapter > > I am using MSSQL all the time and that is working for me.
Thanks pepe. I had gone to RubyGems.org and it instructed me to do the same thing you advised and it works! 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; My ruby client is on windows so I think I need a dsn. Each time I try to set up a dsn I get the error: SQLState 42000 SQL Server Error: 4064 Any idea what I'm doing wrong? Thanks again for the help. -- 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.

