On Dec 16, 12:05 pm, lkfken <[email protected]> wrote: > I am trying to get data out from MSSQL and for some unknown reasons to > me that some of these data is showing "nil" under Ruby/Sequel. > However, when I use MS Access to connect to the same MSSQL database, I > could see the data just fine. > > In short, the data is there but somehow Sequel fail to get them??
You could try a different adapter, for example odbc or jdbc (with JRuby). On Windows, I'd definitely recommend using JRuby and the jdbc adapter with either the Microsoft sqlserver jdbc driver or the jtds driver. That being said, I do use the ado adapter with MSSQL 2000 in a limited capacity and it does work, though I haven't tried it with large text fields. 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.
