hello andy, hello all others who answered my post,
first of all thank you for letting me know the positive experiences you have had with the ODBC adaptor and your various installations. i'm relieved that Zope and window's DB's do work together -- and this prompted some new tests on my part.
their still seems to be a minor issue with an error message the first time we query a MS SQL 6.5 DB. a few reloads later everything seems to work fine. kind of weird.
there used to be a similar issue in a previous version, that had to do with single threads and transactions not being committed. But that was patched long ago. That's probably not it and I know it's kind of cryptic, just thought I'd bring it up, just in case.
guess the only major thing left is the single thread issue.
yes, that's bad. Rik