RE: [Zope] Newbie SQL problem: Query Error: Cannot render query template
When I try to test my connection (http://jester/profiles/Jet_database_connection/manage_test). SQL is as follows: INSERT INTO test VALUES ( 'line one', 123456) I get an error with the following traceback: Error Type: Query Error Error Value: Invalid Operation Traceback (innermost last): File C:\PROGRA~1\JESTER\lib\python\ZPublisher\Publish.py, line 222, in publish_module File C:\PROGRA~1\JESTER\lib\python\ZPublisher\Publish.py, line 187, in publish File C:\PROGRA~1\JESTER\lib\python\Zope\__init__.py, line 221, in zpublisher_exception_hook (Object: RoleManager) File C:\PROGRA~1\JESTER\lib\python\ZPublisher\Publish.py, line 171, in publish File C:\PROGRA~1\JESTER\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: manage_test) File C:\PROGRA~1\JESTER\lib\python\ZPublisher\Publish.py, line 112, in call_object (Object: manage_test) File C:\PROGRA~1\JESTER\lib\python\Shared\DC\ZRDB\Connection.py, line 180, in manage_test (Object: RoleManager) File C:\PROGRA~1\JESTER\lib\python\Products\ZJetDA\db.py, line 130, in query Query Error: (see above) Testing my SQL inside Access yields expected results. The SQL is fine. If a user tries to access a dtml_document that trys to modify the database, they get the same error. I'm thinking that Zope 2.2.0 and 2.2.1 have some big problems with DA's under Windoze. Unfortunately, my app _MUST_ use Access. I'm not thrilled. Can anyone more familiar with Python clue me 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 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 ) 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 >> (, ) >> 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:[EMAIL PROTECTED] >> http://www.williams.com ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Newbie SQL problem: Query Error: Cannot render query template
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 ) 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 >> (, ) >> 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:[EMAIL PROTECTED] >> http://www.williams.com >> >> >> ___ >> Zope maillist - [EMAIL PROTECTED] >> 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 - [EMAIL PROTECTED] >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 ) ___ Zope maillist - [EMAIL PROTECTED] 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 )
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 > (, ) > 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:[EMAIL PROTECTED] > http://www.williams.com > > > ___ > Zope maillist - [EMAIL PROTECTED] > 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 - [EMAIL PROTECTED] 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 )