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

2000-09-01 Thread Farrell, Troy
-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 under Win NT always make

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

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:

[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 (dtml-sqlvar value_one type=string, dtml-sqlvar value_two type=int) returns