From: Robo <robo@...>
Date: 2004-10-26T08:54:05+09:00
Subject: Re: DBI with SQL Server

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