Hi, I have an application that uses Sequel (2.8.0). It was built against MySQL and works fine there. However due to infrastructure limitations I need to get it working against MSSQL (2000).
It looks like either the odbc/mssql adapter is not up-to-date or possibly it supports SqlServer 2005+ but is not backwards compatible with SqlServer 2000. The issues I have been encountering are: * attempting to quote column names with " (not valid) rather than surrounding them in [] * wrapping table names in parentheses (not valid) - they can be quoted using [] * when calling dataset.count it generates something like "select NCOUNT (*) from table" which isn't valid * when writing a date/time to the database it is trying to use an iso format which doesn't work with 2000. * when writing a String to the database it is escaping \ (backslash) characters even though SqlServer 2000 does not give backslash a special meaning. I'm not sure how much further the rabbit-hole goes. I've managed to patch these issues but as I mention above, I'm not sure whether I am undoing support for 2005 or whether this adapter simply isn't being used - or I have something else broken in my environment. Any information would be appreciated. Right now I'm going to see if I can convince management to let me set up MySQL since I know the application works fine there. Thanks for any help. Cheers, Pete. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
