From: Warren Brown <WBrown@...>
Date: 2004-10-26T07:29:45+09:00
Subject: Re: DBI with SQL Server

Eli,

> Can someone give me a little help with DBI when
> connecting to SQL Server?
> ...
> db = DBI.connect("DBI:ODBC:driver={SQL
> Server};Server=kint;Database=MyJournal;UID=test;PWD=test")

    If you are using ODBC, you should be able to use:

db = DBI.connect("dbi:ODBC:myodbcdatasourcename")

    You can set up the rest of the information in the ODBC datasource
itself.

    I hope this helps.

    - Warren Brown