In Access, that field is call "memo", so it makes sense to see how
Sequel shows
{:db_type=>"text",
:max_chars=>2147483647, ...}
I tried to use odbc as described at
http://sequel.rubyforge.org/rdoc/files/doc/opening_databases_rdoc.html
Unfortunately, I couldn't get it to work as I got
Sequel::AdapterNotFound.
Do you have a solution for this?
On Dec 16, 12:22 pm, Jeremy Evans <[email protected]> wrote:
> 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.
