It blew as soon as I called:
conn = WIN32OLE.new('ADODB.Connection')
IronRuby 1.1.0.0 on .NET 4.0.30319.1
Copyright (c) Microsoft Corporation. All rights reserved.
>>> require 'win32ole'
=> true
>>> conn = WIN32OLE.new('ADODB.Connection')
(ir):1:in `inspect': Operation is not allowed when the object is
closed. (System::Runtime::InteropServices::COMException)
from (ir):1
Do I need to install MDAC or something silly like that?
On Aug 25, 12:48 pm, rohit <[email protected]> wrote:
> On Aug 25, 9:25 am, Brett Veenstra <[email protected]> wrote:
>
> > 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:
>
> Try running this with MRI and IronRuby, might help to isolate if the
> problem is in Sequel or IronRuby or elsewhere.
>
> require 'win32ole'
>
> conn = WIN32OLE.new('ADODB.Connection')
> conn.Provider = 'SQLNCLI'
> conn.Open("driver='SQL
> Server';server=localhost;database=some_db;uid=some_user;pwd=some_pwd")
> rs = WIN32OLE.new('ADODB.Recordset')
> rs.Open('select * from some_table', conn)
> p rs.getRows
--
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.
