Even more trials that have the same failure...
Instead of "each" call, I just am trying this now:
DB.test_connection(nil)
On Aug 25, 8:58 am, Brett Veenstra <[email protected]> wrote:
> 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.
