[Zope] ODBC and Zserver problems

Amos Latteier amos@aracnet.com
Sun, 30 May 1999 10:51:14 -0700


At 07:11 PM 5/30/99 +1200, Graham Chiu wrote:
>
>When I start up Zserver using a batch file, or manually, I am able to
>make my ODBC connections, and see my ODBC datasources.
>
>However, if I start up Zserver as a NT service (zserver-srvany.zip),
>although Zope works fine in other apparent respects, it is now unable to
>see or access ODBC datasources.

If you want to make your DNS's available to other users, you need to create
them as system DSN's. This is not a ZServer specific issue. When you run a
service, it doesn't have the same sort of access to the system as a program
you run manually from a batch file.

Notice in Control Panels/ODBC that you can choose between "User DSN" and
"System DSN". Recreate your DSN as a System DSN, and I bet that all will be
well.

Good luck.

-Amos