[Zope] ZODBC connection & start method

[Stephen Nosal]

Folks -

I'm now finding some interesting behavior with the ZODBC connection.

I set up a connection and had no problems with it (requires DSN id password).

I went back to it at a later point in time and it no longer worked. What changed?

I'm running ZOPE 2.1.6 on NT4 sp4. I started out running ZOPE from the start.bat file.

type start.bat
"c:\zope\ZopeDIR\bin\python.exe" "c:\zope\ZopeDIR\z2.py" -D -w 80 -a 127.0.0.1

If I start ZOPE from the start.bat file, the ODBC connection works flawlessly (with my minor testing)

If I start ZOPE as a service (HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\ZopeDIR\Parameters = "c:\zope\ZopeDIR\bin\python.exe" "c:\zope\ZopeDIR\z2.py" -S -D -w 80 -a 127.0.0.1)

and then attempt to open the ODBC connection, I receive the following error

Invalid connection string: DSN id password (changed for obvious reasons)


Traceback (innermost last):
  File c:\zope\ZopeDIR\lib\python\ZPublisher\Publish.py, line 214, in publish_module
  File c:\zope\ZopeDIR\lib\python\ZPublisher\Publish.py, line 179, in publish
  File c:\zope\ZopeDIR\lib\python\Zope\__init__.py, line 202, in zpublisher_exception_hook
    (Object: RoleManager)
  File c:\zope\ZopeDIR\lib\python\ZPublisher\Publish.py, line 165, in publish
  File c:\zope\ZopeDIR\lib\python\ZPublisher\mapply.py, line 160, in mapply
    (Object: manage_open_connection)
  File c:\zope\ZopeDIR\lib\python\ZPublisher\Publish.py, line 102, in call_object
    (Object: manage_open_connection)
  File c:\zope\ZopeDIR\lib\python\Shared\DC\ZRDB\Connection.py, line 209, in manage_open_connection
    (Object: RoleManager)
  File c:\zope\ZopeDIR\lib\python\Shared\DC\ZRDB\Connection.py, line 227, in connect
    (Object: RoleManager)
  File c:\zope\ZopeDIR\lib\python\Products\ZODBCDA\db.py, line 155, in __init__
BadRequest: (see above)

Has anyone experienced this before? Any thoughts? I much prefer running Zope as a service, but...

TIA.

- Steve

__________________________________________________________________
Get your Private, Anti-Spam, Free Email at http://e3mil.com 
and Step into a Friendly Universe!