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