Thanks for that clarification, Jeremy. On Nov 27, 7:08 pm, Jeremy Evans <[email protected]> wrote: > On Nov 27, 2:49 am, Ciaran Archer <[email protected]> wrote: > > > Hi there > > > Are there any performance benefits to using ADO over JDBC when > > connecting to SQL Server 2000 with Sequel? And if there were, are > > there any Sequel features not supported by ADO that are supported by > > JDBC? > > Sequel's ado adapter has serious shortcomings, and I wouldn't > recommend its use for any app that needs to write to the database. > Read-only apps can probably use ado safely. Setting a specific ado > provider does help things somewhat, but there are usually better > options. The only advantage of the ado adapter is that the underlying > driver (win32ole) ships with ruby. > > If you are using JRuby, I would recommend the JDBC adapter to access > SQL Server. Otherwise, I would recommend the tinytds adapter. > > 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.
