DBI, Sql Server, and Windows Security

ruby-talk
1

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