DSN-less connection

Hi,
I want to connect to a SQL Server or Orcale without a DSN configuration,
is it possible in Ruby??

Any idea?