[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

DBI, Sql Server, and Windows Security

Brian Takita

5/2/2005 5:14:00 PM

Hello,

Is is possible to use windows integrated security with the Sql Server
version of DBI?

I'd like to use an existing ORM such as ActiveRecord or Kansas with a
client application.
I'd rather not store the database login on the client machine.

If DBI does not support integrated security, is there another way to
keep the login hidden?

Thank you,
Brian Takita
3 Answers

Brian Takita

5/2/2005 7:37:00 PM

0

> If DBI does not support integrated security, is there another way to
keep the login hidden?

There is a package named dbi-dbrc that obfusticates the login data.

I would still feel safer using Windows Authentication.

Would it be feasible for DBI to allow a way to accept custom connection
strings?
This would allow DBI to use database features that are not immediately
generated by DBI.

Michael Neumann

5/2/2005 8:49:00 PM

0

Am Monday 02 May 2005 21:39 schrieb Brian Takita:
> > If DBI does not support integrated security, is there another way to
>
> keep the login hidden?
>
> There is a package named dbi-dbrc that obfusticates the login data.
>
> I would still feel safer using Windows Authentication.
>
> Would it be feasible for DBI to allow a way to accept custom connection
> strings?

I don't understand this. Can you explain?

> This would allow DBI to use database features that are not immediately
> generated by DBI.

Regards,

Michael

Brian Takita

5/2/2005 9:46:00 PM

0

Oops...

It looks like you can pass a custom connection string to DBI.

The following connection string works:

dbh = DBI.connect(DBI:ADO:Provider=SQLOLEDB;Data Source=SERVER;Initial
Catalog=DATABASE;Integrated Security=SSPI;)

I was thrown off by the userid and password arguments.
I'm sorry to trouble you and thanks for responding.