As a novice (who's loving Zope!) I'm having a terrible time trying to get Zope1.10.2 on NT with IIS to connect to MS SQL with a Z ODBC connection. Previously I had no problem getting Zope 1.9/ZopeHTTPServer to connect to MS SQL via Z ODBC. Recently I upgraded to 1.10.2 without a hitch, and was able to run it with IIS 4.0 after putting the (PCGI executable?) MYZOPE.exe in /InetPub/scripts/ and turning off in IIS both Basic Authentication and NT Challenge/Response as I read here in the list. My problem now is that when I try to open my db connection (exactly the same connection that was working with 1.9 & ZopeHTTPServer) I get the following error from IIS:
HTTP Error 400 400 Bad Request Due to malformed syntax, the request could not be understood by the server. The client should not repeat the request without modifications.
In trying to figure out what's going on I've noticed a couple things. First, and I think most illustrative, if I try to add a new Z ODBC connection, none of my ODBC sources are showing up in the available list (except the default 'LocalServer, SQL Server') - whereas if I run my 1.9 Zope with ZopeHTTPServer all my ODBC connections show up just fine. Also, running my new 1.10.2 Zope/IIS with the faulty db connection side by side with the functioning 1.9/ZopeHTTPServer, I printed our the environment variables of both and noticed some differences - USERPROFILE's are Default User vs. Administrator, and the 1.9/ZopeHTTPServer contains variables not contained in the 1.10.2/IIS environ: HOMEPATH, TEMP, USERNAME, HOMEDRIVE, USERDOMAIN, PROMPT, LOGONSERVER, TMP. I attempted to set at least USERDOMAIN in the 1.10.2/IIS environ, with no luck. I've read all the posts from the list that I could find dealing with IIS and ODBC, but couldn't find anything with info on this type of trouble. Have I made a boneheaded mistake and started to look in the wrong places for the fix? Any help/info/pointers would be hugely appreciated as I continue to bang my head on my keyboard hoping that I'll soon clear this hurdle and get back to having fun with Zope! Thanks! Jay