From: dkmd_nielsen <donn@...>
Date: 2008-01-26T06:55:02+09:00
Subject: Re: ActiveRecord connect to SqlServer

On Jan 25, 4:00 am, Dejan Dimic <dejan.di...@gmail.com> wrote:
> On Jan 24, 6:34 pm, 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
>
> You can make a User DSN throughout ODBC Data Source Administrator for
> example named MyExpressDB using SQL Native Client driver.
>
> Then your connection settings should be:
>
> ActiveRecord::Base.establish_connection(
>   :adapter  => "sqlserver",
>   :mode => "ODBC",
>   :dsn => "MyExpressDB"
> )
>
> and sit back and enjoy

Thanks to all.  I setup the ODBC connection and it is working
perfectly.  All I did was change the :mode to "ODBC", and that was it.

dvn