You will definitely want to pass the :db_type => 'mssql' option when connecting via odbc to Sql Server. This will take care of those funny names and bracketing things with [ and ]. Field names are also properly handled via sequel, but only if you pass the aforementioned option.
Michael On Wed, Sep 1, 2010 at 6:21 PM, mjskier <[email protected]> wrote: >> It sounds like it gets mediated by the DB connector, then. > > Not sure. The MS SQL is obviously on a windows machine, but I access > it from Linux through odbc/freetds > The MySQl is all Linux that I access with a straight > Sequel.connect(:adapter => 'mysql') > > One extra wrench in the MS SQL db is that one table is named 'Order'. > The db browser I'm using (RazorSQL) can't deal with that because Order > is a keyword. Easy workaround is to run a query where Order is quoted > as [Order] > I was expecting this to trip Sequel, but DB[:order] worked like a > charm. But maybe that's an added issue when using the ORM route > instead of simple queries like DB[:order]. I should find out tonight. > > -- > 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. > > -- http://codeconnoisseur.org -- 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.
