[Zope] Problem with ZODBCDA-3.1.0b2

Wed, 29 Sep 1999 23:39:01 +0200

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 )
> 