如何用Ruby连接SQL Server 2005

require 'win32ole'
connection = WIN32OLE.new('ADODB.Connection')
connection.open("Provider=SQLOLEDB.1;User ID=sa;password=xxxx;Data Source=localhost,1433;Initial Catalog=mydb")

最重要的一点是即使默认端口1433也要加上，不然会报错：
sql.rb:27:in `method_missing': open (WIN32OLERuntimeError)
    OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server
      [DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection.
    HRESULT error code:0x80020009
      Exception occurred.    from sql.rb:27:in `open'
    from sql.rb:63