RE: [Zope] Newbie SQL problem: Query Error: Cannot render query template

2000-09-01 Thread Farrell, Troy
in on this? Troy Farrell -Original Message- From: Philipp Auersperg [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2000 10:14 AM To: [EMAIL PROTECTED]; Stephen Nosal Subject: Re: [Zope] Newbie SQL problem: Query Error: Cannot render query template When starting Zope as a service

Re: [Zope] Newbie SQL problem: Query Error: Cannot render query template

2000-08-31 Thread Philipp Auersperg
When starting Zope as a service under Win NT always make sure that the ODBC data sources you use are *system* data sources and not *user* data sources. This could explain why your ODBC connections work when you start Zope from the console and don't work when starting it as service. Anyhow:

Re: [Zope] Newbie SQL problem: Query Error: Cannot render query template

2000-08-31 Thread Stephen Nosal
Troy- Have you tried running this from the DOS prompt? I ran into all sorts of problems running 2.1.6 on NT4WS with the ODBCDA. Everything was fine when I used the start and stop scripts from the command line. When I moved to starting zope as a service, my ODBC connections kept failing. Never

[Zope] Newbie SQL problem: Query Error: Cannot render query template

2000-08-30 Thread Farrell, Troy
Hello. I am running Zope as a service on NT4WS. I have multiple MS Access databases connected to different ZJetDAs and I am not able to modify the data in them with SQL statements. For example, INSERT INTO test VALUES (, ) returns the error "Query Error: Cannot render query template". Can you