On May 20, 4:25 am, "Shawn J. Goff" <[email protected]> wrote: > I receive the following after I pull a query using Sequel.ado() on a > Windows Server 2008 system. > > WIN32OLERuntimeError: failed to create WIN32OLE object from > `ADODB.Connection' HRESULT error code:0x800401f0 CoInitialize has not > been called. > > It never happens on the first query. Sometimes not on the second or > third, but it always eventually comes up within a few tries, and then > it doesn't go away until I restart Sinatra. > > Some searching gave me someone else > (http://redmine.ruby-lang.org/issues/show/2618 > ) who had a similar error using win32ole. But I've seen no solution. > I've tried this with 1.9.1 and 1.9.2dev. > > I was hoping someone here would have some ideas on how to fix this.
I haven't seen that error message before. Do you get the same error message on 1.8? I would recommend using the ODBC adapter instead of the ADO adapter if you are connecting to SQL Server, or the JDBC adapter if you don't mind using JRuby. If you must use the ADO adapter, you probably want to specify a :provider option, as the default :provider that ADO uses has a lot of issues. Jeremy -- 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.
