On Fri, Oct 22, 2010 at 9:35 AM, Fredrik TiC Jansson <
[email protected]> wrote:

> Hello i am a relative noob to the web world and i am now atempting to
> move a rails app to a windows server and connect it to a SQL 2008
> database
>
> in database.yml file
>
>  adapter: sqlserver
>  mode: odbc
>  dsn: Driver={SQL Native
> Client};Server=localhost;Database=DMBackEndServer;username=DM;Pwd=DM;
>
> in gemfile
> gem 'activerecord-sqlserver-adapter'
>
> i have also setup a system data source via microsoft odbc  data source
> administrator tool
>
> but all i get no matter how hard i try is
>
> LoadError (no such file to load -- odbc):
>
>
> What am i missing here ??
>
> Help would be much apprechiated
>
>

if you are connecting to MS sql you should be using

adapter: sqlserver
mode: ado
database: blahblah
host: mode_blah

-- 
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.

Reply via email to