Dbi help required

Ruby
1

D:\Documents and Settings>irb
irb(main):001:0> require ‘dbi’
=> true
irb(main):002:0> conn=DBI.connect(‘LPM’,‘sm_user’,‘smuser_0496’)
DBI::InterfaceError: Invalid Data Source Name
from C:/Ruby187/lib/ruby/gems/1.8/gems/dbi-0.4.5/lib/dbi.rb:
333:in pars e_url' from C:/Ruby187/lib/ruby/gems/1.8/gems/dbi-0.4.5/lib/dbi.rb: 159:in_get
_full_driver’
from C:/Ruby187/lib/ruby/gems/1.8/gems/dbi-0.4.5/lib/dbi.rb:
145:in `conn
ect’
from (irb):2

can someone point out where i am makeig a mistake. my odbc connection
seems to connect to sql server successfully but i cannot do it from
ruby.

2

Afaik, DBI is pretty much dead today. Unless you absolutely have to
stick with it, you could try something more up-to-date, like “sequel”.
I used to patch DBI here and there, in a forked repository at github,
but gave up, eventually. (I deleted that fork, unfortunately).