On Mar 31, 11:49 am, Johnathan <[email protected]> wrote: > Hi Jeremy, > > really appreciate your quick answers and dedication to every problem! > > Extended the paste with logger output:http://pastie.org/1738735
>From the logger output, it appears that Sequel is only sending each query once. It's possible WIN32OLE/SQLNCLI10 is sending the queries multiple times to the server, but Sequel has no control over that. It must be doing something fishy, since Sequel definitely isn't sending any queries like "select * from SELCT FROM X". I think that the "SELECT TOP (1) * FROM [CUSTOM_INSERTS]" is being sent to get the columns when you create the model class, since the table doesn't exist in the schema (the schema query doesn't raise an error, but it doesn't return any rows). The columns error is caught, which makes sense since the query to get the columns is allowed to fail. FYI, I strongly recommend against using the ado adapter in production other than for read-only workloads. I'd recommend using the odbc adapter instead in your case. On Windows, your best bet is JRuby and the jdbc adapter with the sqlserver JDBC driver or the jtds JDBC driver, but I can understand that that is not an easy switch. 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.
