DBI, Sql Server, and Windows Security

[Brian Takita]

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

 

[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?
This would allow DBI to use database features that are not immediately
generated by DBI.

 

[Michael Neumann]

Am Monday 02 May 2005 21:39 schrieb Brian Takita:

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]

Oops...

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

The following connection string works:

dbh = DBI.connect(DBI:ADOrovider=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.