> > This was a bug in the assistance gem. I pushed out a new release so it > should be available in a few hours.
Would this also fix my poblem? The following code using ADO fails. db = Sequel.ado 'db_name', :user => 'sa', :password => 'some_pwd', :host => 'my_computer_name' sql = 'select top 1 * from table' db[sql].each {|r| p r} This causes the following error. d:/ruby/lib/ruby/gems/1.8/gems/sequel_core-1.0.10/lib/sequel_core/ adapters/ado.rb:26:in `method_missing': Open (WIN32OLERuntimeError) OLE error code:80004005 in Microsoft OLE DB Provider for ODBC Drivers [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified HRESULT error code:0x80020009 Exception occurred. from d:/ruby/lib/ruby/gems/1.8/gems/ sequel_core-1.0.10/lib/sequel_core/adapters/ado.rb:26:in `connect' from d:/ruby/lib/ruby/gems/1.8/gems/sequel_core-1.0.10/lib/ sequel_core/database.rb:27:in `initialize' from d:/ruby/lib/ruby/gems/1.8/gems/assistance-0.1.4/lib/assistance/ connection_pool.rb:108:in `call' from d:/ruby/lib/ruby/gems/1.8/gems/assistance-0.1.4/lib/assistance/ connection_pool.rb:108:in `make_new' from d:/ruby/lib/ruby/gems/1.8/gems/assistance-0.1.4/lib/assistance/ connection_pool.rb:100:in `available' from d:/ruby/lib/ruby/gems/1.8/gems/assistance-0.1.4/lib/assistance/ connection_pool.rb:91:in `acquire' from d:/ruby/lib/ruby/gems/1.8/gems/assistance-0.1.4/lib/assistance/ connection_pool.rb:90:in `synchronize' from d:/ruby/lib/ruby/gems/1.8/gems/assistance-0.1.4/lib/assistance/ connection_pool.rb:90:in `acquire' from d:/ruby/lib/ruby/gems/1.8/gems/assistance-0.1.4/lib/assistance/ connection_pool.rb:57:in `hold' from d:/ruby/lib/ruby/gems/1.8/gems/sequel_core-1.0.10/lib/ sequel_core/database.rb:150:in `synchronize' from d:/ruby/lib/ruby/gems/1.8/gems/sequel_core-1.0.10/lib/ sequel_core/adapters/ado.rb:57:in `fetch_rows' from d:/ruby/lib/ruby/gems/1.8/gems/sequel_core-1.0.10/lib/ sequel_core/dataset.rb:174:in `each' from D:/Source/ruby/engine/test/sequel_test.rb:20 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to sequel-talk@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en -~----------~----~----~----~------~----~------~--~---