Right now I''m connecting to a remote MSSQL db using sqljdbc4.jar from Netbeans, which works fine for Java. However, for Ruby (not Jruby, note), what''s best? Would this adapter work: http://github.com/rails-sqlserver/2000-2005-adapter I ask because the MSSQL db expects a JDBC connection, I think, wheras the Ruby adapter won''t be JDBC (does the db even know?). My connection info is like so: Database URL: jdbc:sqlserver://foo.com:1433;databaseName=bar Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver Schema: baz User: foobar at least, that''s how it appears in the IDE. Microsoft doesn''t have Ruby driver as they do for JDBC http://support.microsoft.com/kb/313100 ? Can this info basically be copied over to the database.yml file? I notice projects like: http://kenai.com/projects/jruby/pages/ActiveRecord-JDBC however, I''d prefer to stick with "regular" Ruby over JRuby. I don''t have to use JRuby for the connection, do I? thanks, Thufir -- 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.