First off, i'm on ubuntu trying to connect to sql server 2008..
I installed the latest version of the activerecord-sqlserver-adapter
gem (2.3.4). in my database.yml i first tried connecting with the
mode: ADO, but got this message:
Please use version 2.3.1 of the adapter for ADO connections. Future
versions may support ADO.NET.
Ok.. so i try swapping my database.yml with this:
development:
adapter: sqlserver
mode: odbc
dsn: Driver={SQL Server Native
Client};Server=xxx.xx.x.xxx;Database=testing;Uid=sa;Pwd=*******;
now i get this message when i try to db:migrate:
S1090 (0) [unixODBC][Driver Manager]Invalid string or buffer length
i did a gem install for odbc-rails, but still getting the same. trying
to find solutions on the net is frustrating because there's such a mix
of different ways to connect (ado, odbc, dbi, etc) and some are from
the perspective of connecting from windows or mac osx.. to compound
things a lot of the stuff is older so i'm constantly wondering if
there's a new better way..
i'm used to connecting to mysql painlessly.. i don't know much about
odbc, dbi, ado or any of that. i just want to know what the best and
most current way to connect to a sql server db is.
Help me please! I just want to start coding!
Stuart
--
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-t...@googlegroups.com.
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.
