Re: [Zope] Newbie SQL problem: Query Error: Cannot render query template
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!
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 )
participants (2)
-
Philipp Auersperg -
Stephen Nosal