[Zope] need help with IIS/ODBC

[Amos Latteier]

At 05:31 PM 3/4/99, Jay Ashton  wrote:

>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 think at least this part of your problem may be due to the fact that Zope
is running as a different user under IIS than it is under ZopeHTTPServer.
My guess is that it can't see your datasources since they weren't created
as 'System' datasources. Check under the windows ODBC control panel and
make sure your DSNs appear under 'system dsn', not 'user dsn'.

-Amos