From: Horacio Sanson <hsanson@...>
Date: 2005-11-07T12:10:57+09:00
Subject: Re: MS SQL Access from Ruby in Windows

 
Sean,

I am trying to do a DSN-Less connection to my MS SQL 2000 server as you told 
me in your email bu I cannot get it to work.

I get this error

Error S1090 (0) [unixODBC][Driver Manager]Invalid string or buffer length

Googling I found this thread that says ODBC does not support DSNLess 
connections and was wondering how you did to get this working. Using DSN 
works ok.

http://blade.nagaokaut.ac.jp/cgi-bin/scat.rb/ruby/ruby-talk/67352


Another question I have is what is the advantage of using DSN vs DSNLess?? I 
prefer DSNLess to avoid external configurations in the running PC so my Ruby 
script is easily executed in different machines.

thanks,
Horacio

Saturday 05 November 2005 02:03、Sean O'Halpin さんは書きました:
> rescue DBI::DatabaseError => e
>   puts "Error #{e.errstr}"
> ensure
>   # disconnect from server
>   db.disconnect if db
> end