What a cool gem!
I'm using IronRuby and trying to get Sequel to talk to a MSSQL
database.
When I run the following code (in Rake)
require 'sequel'
settings = LocalSettings.new.settings
DB = Sequel.connect(:adapter=>'ado',
:host=>settings[:sql_server],
:database=>settings[:sql_database],
:user=>settings[:sql_userid],
:password=>settings[:sql_userpwd],
:provider=>'SQLNCLI10')
foos = DB.from(:tbl_foo)
foos.each do |item|
puts "Name" + item.Name
end
I get:
System::Runtime::InteropServices::COMException: Operation is not
allowed when the object is closed. while calling Provider=
>> This blows on the "each" call.
Any ideas/tips for this newbie? Thanks!
--
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.
