Ok, so I am getting an error with this one. However, I also get the
same error using just the ODBC adapter.
>> require 'sequel/adapters/odbc-mssql'
=> true
>> DB = Sequel::ODBC::MSSQL::Database.new(:database => "XXXX" :user => "XXXX",
>> :password => "XXXX")
=> #<Sequel::ODBC::MSSQL::Database:0x12b82d8
@opts={:user=>"XXXX", :password=>"XXXX", :database=>"XXXX"},
@pool=#<Sequel::ConnectionPool:0x12b8224 @allocated={}, @max_size=4,
@available_connections=[], @connection_proc=#<Proc:0x0034b5d4@/Library/
Ruby/Gems/1.8/gems/sequel-0.4.1.1/lib/sequel/database.rb:27>,
@created_count=0, @mutex=#<Mutex:0x12b81e8>>, @logger=nil,
@single_threaded=false>
>> puts DB.to_yaml
--- !ruby/object:Sequel::ODBC::MSSQL::Database
logger:
opts:
:user: XXXX
:password: XXXX
:database: XXXX
pool: !ruby/object:Sequel::ConnectionPool
allocated: {}
available_connections: []
connection_proc: !ruby/object:Proc {}
created_count: 0
max_size: 4
mutex: !ruby/object:Mutex {}
single_threaded: false
=> nil
>> DB[:"master..sysprocesses"].filter('blocked != 0').all
NameError: uninitialized constant ODBC
from /Library/Ruby/Gems/1.8/gems/sequel-0.4.1.1/lib/sequel/adapters/
odbc.rb:13:in `connect'
from /Library/Ruby/Gems/1.8/gems/sequel-0.4.1.1/lib/sequel/
database.rb:27:in `initialize'
from /Library/Ruby/Gems/1.8/gems/sequel-0.4.1.1/lib/sequel/
connection_pool.rb:109:in `call'
from /Library/Ruby/Gems/1.8/gems/sequel-0.4.1.1/lib/sequel/
connection_pool.rb:109:in `make_new'
from /Library/Ruby/Gems/1.8/gems/sequel-0.4.1.1/lib/sequel/
connection_pool.rb:101:in `available'
from /Library/Ruby/Gems/1.8/gems/sequel-0.4.1.1/lib/sequel/
connection_pool.rb:92:in `acquire'
from /Library/Ruby/Gems/1.8/gems/sequel-0.4.1.1/lib/sequel/
connection_pool.rb:91:in `synchronize'
from /Library/Ruby/Gems/1.8/gems/sequel-0.4.1.1/lib/sequel/
connection_pool.rb:91:in `acquire'
from /Library/Ruby/Gems/1.8/gems/sequel-0.4.1.1/lib/sequel/
connection_pool.rb:58:in `hold'
from /Library/Ruby/Gems/1.8/gems/sequel-0.4.1.1/lib/sequel/
database.rb:151:in `synchronize'
from /Library/Ruby/Gems/1.8/gems/sequel-0.4.1.1/lib/sequel/adapters/
odbc.rb:52:in `fetch_rows'
from /Library/Ruby/Gems/1.8/gems/sequel-0.4.1.1/lib/sequel/dataset.rb:
163:in `each'
from (irb):7:in `all'
from (irb):7
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---