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
don't work when starting it as service.
Zope 2.1.6 is not the best for SQL (problems with recordsets show up when used
Zope 2.2.0 has problems with ZODBC under Windows 2000 (Authorisation dialogs
Use 2.1.4 or 2.2.1 (does it fine with SQL under Linux and Windows )
*********** REPLY SEPARATOR ***********
On 31.08.2000 at 06:40 Stephen Nosal wrote:
>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
>It's worth a try.
>On Wed, 30 August 2000, "Farrell, Troy" wrote:
>> 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.
>> Troy Farrell
>> Troy Farrell
>> Video Operations Technician II
>> Williams VYVX Services
>> 918.573.1441 fax
>> mailto:[EMAIL PROTECTED]
>> Zope maillist - [EMAIL PROTECTED]
>> ** No cross posts or HTML encoding! **
>> (Related lists -
>> 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]
>** No cross posts or HTML encoding! **
>(Related lists -
> http://lists.zope.org/mailman/listinfo/zope-dev )
Zope maillist - [EMAIL PROTECTED]
** No cross posts or HTML encoding! **
(Related lists -