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.
