After much mucking around, it turns out that the problem only occurs when Zope is running as an NT Service, and when it is running as the System Account. There is some strange environment issue there that I have no idea about, but if I change the service to run as me, than everything seems hunky dory. How odd. Hunter Hunter Kelly wrote:
I can't seem to establish an ODBC connection to any of my ODBC sources. The "Add Z ODBC Database Connection" page seems to come up fine, and lists all my odbc sources, but I have no joy when trying to create a connection with the "Connect immediately" button checked. I tried all of the connections, some of which are SQL server and some are Access thingies, but none of them work.
I've included the source of the page with the error message.
Any thoughts?
Thanks,
Hunter
<HTML><HEAD><TITLE>Zope</TITLE></HEAD><BODY BGCOLOR="#FFFFFF">
<strong>Invalid connection string: </strong><CODE>Demander</CODE><br> <!-- sql.error None -->
<p><a href="http://www.zope.org/Credits"><img src="http://opal:8080/p_/ZopeButton" width="115" height="50" border="0" alt="Powered by Zope"></a></p> </BODY></HTML> <!-- Traceback (innermost last): File E:\PROGRA~1\ZopeTest\lib\python\ZPublisher\Publish.py, line 214, in publish_module File E:\PROGRA~1\ZopeTest\lib\python\ZPublisher\Publish.py, line 179, in publish File E:\PROGRA~1\ZopeTest\lib\python\Zope\__init__.py, line 201, in zpublisher_exception_hook (Object: ApplicationDefaultPermissions) File E:\PROGRA~1\ZopeTest\lib\python\ZPublisher\Publish.py, line 165, in publish File E:\PROGRA~1\ZopeTest\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: manage_addZODBCConnection) File E:\PROGRA~1\ZopeTest\lib\python\ZPublisher\Publish.py, line 102, in call_object (Object: manage_addZODBCConnection) File E:\PROGRA~1\ZopeTest\lib\python\Products\ZODBCDA\DA.py, line 104, in manage_addZODBCConnection (Object: ApplicationDefaultPermissions) File E:\PROGRA~1\ZopeTest\lib\python\Shared\DC\ZRDB\Connection.py, line 124, in __init__ (Object: RoleManager) File E:\PROGRA~1\ZopeTest\lib\python\Shared\DC\ZRDB\Connection.py, line 153, in edit (Object: RoleManager) File E:\PROGRA~1\ZopeTest\lib\python\Shared\DC\ZRDB\Connection.py, line 197, in connect (Object: RoleManager) File E:\PROGRA~1\ZopeTest\lib\python\Products\ZODBCDA\db.py, line 155, in __init__ BadRequest: (see above)
-->
_______________________________________________ Zope maillist - Zope@zope.org http://www.zope.org/mailman/listinfo/zope
(Related lists - please, no cross posts or HTML encoding!
To receive general Zope announcements, see: http://www.zope.org/mailman/listinfo/zope-announce
For developer-specific issues, zope-dev@zope.org - http://www.zope.org/mailman/listinfo/zope-dev )