From: Nikos Polizotis <npolizotis@...>
Date: 2004-10-26T16:24:33+09:00
Subject: Re: DBI with SQL Server

As far as I know tha latest version of the odbc driver works with
connection strings as
well
I am using 

DBI.connect('dbi:ODBC:'+'%q{DRIVER=SQL
Server;SERVER=sqlserver;DATABASE=db;Uid=userid;Pwd=password})

for a standard connection

On Tue, 26 Oct 2004 08:54:05 +0900, Robo <robo@mars.com> wrote:
> Eli Tucker wrote:
> 
> 
> > Hi Warren. Thanks for your help.  That worked.
> >
> > But is there a way to specify the complete connection string and avoid
> > setting up an ODBC data source?  In other words, if I wanted to define
> > all of the parameters in the connection string like the ODBC connection
> > string "Driver={SQL
> > Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;", is there a way
> > to do that?
> >
> > Thanks again for your help!
> >  - Eli
> > 
> I think the usual convention is something like:
> 
> db = DBI.connect("dbi:ODBC:dsn:localhost", "user", "pw")
> 
> Robo
> 
>