The ODBC adapter implements a huge, complex, distributed object-oriented architecture in its code just to prevent you from seeing a clear, meaningful error message. *wink* Really, the error it spews out can mean anything -- from the data source being configured incorrectly to not being able to connect to the server. The adaptor doesn't tell you, and so nobody here can help you except tell you to check the ODBC DSN from another application -- Microsoft Query, a Delphi app, anything. (Using the mxODBC Python module is not recommended as it's not bug-free. Its author admitted to me that he had only tested it with Access; it didn't work fully with MS SQL Server until a couple of months ago.) What the adaptor should do, ideally, is to use SQLGetDiagRec() to iterate over the error diagnostics and build a list of SQL states, their error codes, and so on. It doesn't do this. A patch might be in order here. -- Alexander Staubo http://www.mop.no/~alex/ "`This must be Thursday,' said Arthur to himself, sinking low over his beer, `I never could get the hang of Thursdays.'" --Douglas Adams, _The Hitchhiker's Guide to the Galaxy_
-----Original Message----- From: Hunter Kelly [mailto:retnuh@oniva.com] Sent: 29. september 1999 17:45 To: zope@zope.org Subject: [Zope] 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)
-->
_______________________________________________ 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 )