Problem with ZODBCDA-3.1.0b2
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) -->
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 )
At 17:23 1-10-99 , Hunter Kelly wrote:
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.
Are your DSNs User DSNs or System DSNs? User DSNs are only visible to you, while System DSNs are visible to everyone logging into your system, including services. -- Martijn Pieters, Web Developer | Antraciet http://www.antraciet.nl | T: +31 35 7502100 F: +31 35 7502111 | mj@antraciet.nl http://www.antraciet.nl/~mj | PGP: http://wwwkeys.nl.pgp.net:11371/pks/lookup?op=get&search=0xA8A32149 ---------------------------------------------
The ones I was trying to connect to were System DSN's. They would come up in the selection box, but it wouldn't allow a connection at all, unless the service was running as me. H Martijn Pieters wrote:
At 17:23 1-10-99 , Hunter Kelly wrote:
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.
Are your DSNs User DSNs or System DSNs?
User DSNs are only visible to you, while System DSNs are visible to everyone logging into your system, including services.
-- Martijn Pieters, Web Developer | Antraciet http://www.antraciet.nl | T: +31 35 7502100 F: +31 35 7502111 | mj@antraciet.nl http://www.antraciet.nl/~mj | PGP: http://wwwkeys.nl.pgp.net:11371/pks/lookup?op=get&search=0xA8A32149 ---------------------------------------------
participants (2)
-
Hunter Kelly -
Martijn Pieters