[Zope] 2.2 as a service and Zodbcda

[Jim Sanford]

Can you shed any insite?

***********Result of testing Z SQL Method with Zope 2.2 running as a service:

 Z SQL Method at /scripts/Zope.pcgi / testing / test2

--------------------------------------------------------------------------------
Error, sql.error: ('S0002', 173, "[Microsoft][ODBC Visual FoxPro Driver]File 'names.dbf' does not exist.")
--------------------------------------------------------------------------------
SQL used:

Could not render the query template!

Registry Parameter= start : REG_SZ : "C:\Progra~1\ATIAny~1\bin\python.exe" "C:\Program Files\ATIAnywhere\z2.py" -D -p
C:\InetPub\scripts\Zope.pcgi
=================================================

************Result of testing Z SQL Method with Zope 2.2 running from start.bat.:

 Z SQL Method at /scripts/Zope.pcgi / testing / test2

--------------------------------------------------------------------------------
Company
ATMEL

--------------------------------------------------------------------------------
SQL used:

select company
from names where val(id)=27000

Start.bat="C:\Program Files\ATIAnywhere\bin\python.exe" "C:\Program Files\ATIAnywhere\z2.py" -D -p C:\InetPub\scripts\Zope.pcgi


=============================================
Both are running via pcgi through MS IIS 4.0

Here is Zope.pcgi:

#!C:\Program Files\ATIAnywhere\pcgi\win32\pcgi-wrapper.exe
#
# This PCGI info file was generated automatically by
# the Zope installer. See the file doc/WEBSERVER.txt
# for more information on setting up PCGI support.

PCGI_NAME=Anywhere
PCGI_PORT=8090
PCGI_MODULE_PATH=C:\Progra~1\ATIAnywhere\lib\python\Main.py
PCGI_PUBLISHER=C:\Progra~1\ATIAnywhere\pcgi\pcgi_publisher.py
PCGI_EXE=C:\Progra~1\ATIAnywhere\pcgi"
PCGI_SOCKET_FILE=C:\Progra~1\ATIAnywhere\pcgi\pcgi.soc
PCGI_PID_FILE=C:\Progra~1\ATIAnywhere\pcgi\pcgi.pid
PCGI_ERROR_LOG=C:\Progra~1\ATIAnywhere\pcgi\pcgi.log
PCGI_DISPLAY_ERRORS=1
BOBO_REALM=Zope
BOBO_DEBUG_MODE=1
INSTANCE_HOME=C:\Progra~1\ATIAnywhere