> I am curious what folks are doing with nsodbc?
>
> I have been playing around with it on Linux, (in conjunction with the
> OpenRDA and Easysoft (unixODBC) Unix ODBC client drivers) connecting to SQL
> Server 7 and it works, sort of.
>
> There appears to be a hardcoded limit such that fields cannot be more than
> 8K in length. That's 8K, not 8G. The field is easily increased raising
> the size of a stack allocated buffer, but clearly, nsodbc lacks a basic
> strategy on how to deal with even moderately sized fields (much less LOBs
> in general.)
>
> So is anyone using this in production? What limitations have you found,
> and how have you worked around them?
I haven't used nsodbc on Unix, but I've used it for testing on Windows machines
with AS2.1 quite a bit. Seems to work fine -- although I didn't have large
columns like that.
Do I understand correctly that the nssybase driver will also work with SQL
Server? I've got to move a database from Illustra (which I won't miss even a
little bit, especially since I'm the last person on the planet who uses it) to
SQL Server (not my choice; the client's) and I'm just now starting to try to
figure things out. Has anyone used this recently? Maybe in production?
Michael
