From: Todd Benson <caduceass@...>
Date: 2008-01-25T02:34:33+09:00
Subject: Re: ActiveRecord connect to SqlServer

On Jan 24, 2008 9:59 AM, dkmd_nielsen <donn@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