DBI with SQL Server

ruby-talk
1

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

2

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

3

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

4

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