From: Paul Rogers <pmr16366@...>
Date: 2008-01-26T11:34:57+09:00
Subject: Re: ActiveRecord connect to SqlServer

On Jan 24, 10:34 am, Todd Benson <caduce...@gmail.com> wrote:
> On Jan 24, 2008 9:59 AM, dkmd_nielsen <d...@cmscms.com> wrote:
>
> > I know you guys have beaten this subject to death, but I'm just not
> > getting a connection to SqlServer 2005.  It is installed locally, with
> > an instance name of DVN-P548.  I use my windows user name and password
> > to log in.
>
> > require 'rubygems'
> > require_gem 'activerecord'
>
> > ActiveRecord::Base.establish_connection(
> >         :adapter => 'sqlserver',
> >         :mode => 'ADO',
> >         :host => 'P548-DVN',
>
> Why is this not DVN-P548?
>
> >         :dsn => '???',                             ** what is this supposed
> > to be???
>
> You shouldn't need that part of the Hash.  Try leaving the :dsn part out.
>
> >         :database => 'CountsAAN',
> >         :username => 'my_windows_userid',
> >         :password => 'my_password'
> > )
>
> > class WiRecord < ActiveRecord::Base
> > end
>
> > Errors I get returned are either "Server does not exist or access is
> > denied" (thanks, MS, for narrowing this one down a bit), or "user is
> > not trusted"
>
> That last error is a bit weird.  That means you're connecting to
> something, but failing.  Maybe look at your permissions?
>
> > , depending on what values I have attempted for host and
> > dsn.  What is host and dsn?  Believe it or not, I do not find a clear
> > definition in the rails handbook.
>
> "host" is the name of the machine you are running the database on.
> This can also be an IP address.  If the database is on the same
> machine, use 127.0.0.1 or localhost.
>
>
>
> > Do I want to use ADO, or should I use ODBC?  If odbc, where does one
> > find the connection string?  Being a windows user, I'm so used to
> > having everything done for me under the covers that I don't understand
> > any of the underlying details.
>
> Hopefully somebody else can answer this.
>
> > Thanks for everything,
> > dvn
>
> Todd

I think this error   "Server does not exist or access is
denied" (thanks, MS, for narrowing this one down a bit), or "user is
not trusted" means you are trying to access a sql server that is
domain authenticated by supplying a sql server authenticated user

Also, when I used ado some time back with rails I got lots of errors,
but switching to odbc mae it work fine.

Paul