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

[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 2.1.6 is not the best for SQL (problems with recordsets show up when used in <dtml-tree>)
	Zope 2.2.0 has problems with ZODBC under Windows 2000 (Authorisation dialogs pop up).

My hint:
	Use 2.1.4 or 2.2.1 (does it fine with SQL under Linux and Windows )


phil

*********** REPLY SEPARATOR  ***********

On 31.08.2000 at 06:40 Stephen Nosal wrote:

>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 did find an NT solution, I just moved everything to Linux.
>
>It's worth a try.
>
>- Steve
>
>On Wed, 30 August 2000, "Farrell, Troy" wrote:
>
>> 
>> 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 the error "Query Error: Cannot render query template".  Can you tell
>> me what the cause is.  I think it might be a permissions problem, but I have
>> everything wide open and I can't figure it out.
>> 
>> Thanks.
>> Troy Farrell
>> 
>> Troy Farrell
>> Video Operations Technician II
>> Williams VYVX Services
>> 918.573.3029
>> 918.573.1441 fax
>> mailto:troy.farrell@wilcom.com
>> http://www.williams.com
>> 
>> 
>> _______________________________________________
>> Zope maillist  -  Zope@zope.org
>> http://lists.zope.org/mailman/listinfo/zope
>> **   No cross posts or HTML encoding!  **
>> (Related lists - 
>>  http://lists.zope.org/mailman/listinfo/zope-announce
>>  http://lists.zope.org/mailman/listinfo/zope-dev )
>
>
>__________________________________________________________________
>Get your Private, Anti-Spam, Free Email at http://e3mil.com 
>and Step into a Friendly Universe!
>
>_______________________________________________
>Zope maillist  -  Zope@zope.org
>http://lists.zope.org/mailman/listinfo/zope
>**   No cross posts or HTML encoding!  **
>(Related lists - 
> http://lists.zope.org/mailman/listinfo/zope-announce
> http://lists.zope.org/mailman/listinfo/zope-dev )