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


 

Forums >

comp.lang.ruby

Re: DBI, Sql Server, and Windows Security

Shashank Date

5/2/2005 10:15:00 PM

Hi Brian,

--- Brian Takita <brian.takita@gmail.com> wrote:
> I would still feel safer using Windows
> Authentication.

I was able to make this work (assuming you have
installed dbi-ado):

#################
require 'dbi'

DBI.available_drivers.each { |driver|
puts 'Driver: ' + driver
if((driver =~ /ADO/) or (driver =~ /ODBC/))
DBI.data_sources(driver).each { |dsn|
puts "\tDatasource: " + dsn
}
end
}

URL = 'dbi:ADO:Provider=SQLOLEDB;Data
Source=P11;Initial
Catalog=master;Trusted_Connection=yes'
dbh = DBI.connect(URL)

__END__
#################

> Would it be feasible for DBI to allow a way to
> accept custom connection
> strings?

I believe it does ... see the URL constant definition
in my code above. Isn't that a custom connection
string?

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

HTH,
-- shanko

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail...