Well I tried running mxodbc and that seems even worse then zodbca when connecting to MS SQLServer... for example queries have to be in exactly the right order: This does not work: select Subtype_Cookbook.discussion, Subtype_Cookbook.resource_id from Subtype_Cookbook This works: select Subtype_Cookbook.resource_id, Subtype_Cookbook.discussion from Subtype_Cookbook Is there something im missing here? Many other people here have connected using zmxodbc to SQLServer with no problem... Cheers. -- Andy McKay. _______________________________________________ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )