In order to use a DSN name, you must first set it up in the control panel 
using ODBC.  You name a data source, you declare its type, i.e. Access, SQL 
server, Oracle, etc.  Then you point to the database. Its pretty simple 
just follow the directions and the dialog boxes.  The second error caused 
the first. There was no DSN therefore no driver was identified and since 
there is no driver Open doesn't exist.

Ernie
At 12:22 1/10/2001 +0900, you wrote:
>Thanks for the quick response, but I tried this code
> > From: Ernest Ellingson [mailto:erne / powernav.com]
> > require 'win32ole'
> > oConn=WIN32OLE.new('ADODB.Connection')
> > oConn.ConnectionString="DSN=xxxxx;uid=xxxx;pwd=xxxx"
> > oConn.Open
> > rs=oConn.Execute("SQLString")
>
>(of course, substituting the xxxxx and SQLString), and I got the following
>error:
>ado2.rb:4:in 'method missing': Open (RuntimeError)
>     OLE rb_compile_error:80004005 in Microsoft OLE DB Provider for ODBC
>Drivers
>     [Microsoft][ODBC Driver Manager] Data source name not found and no
>default driver specified
>Exception occurred
>         from ado2.rb:4
>
>The code worked (with the usual conversions) in a VBScript file.
>
>David Naseby