[Zope] Problem with ZODBCDA-3.1.0b2

Hunter Kelly retnuh@oniva.com
Thu, 30 Sep 1999 12:28:53 +0100


Yah it's kinda a bummer.  I know the ODBC sources work, because they
work
with InterDev and some other applications.  There is something going
on in Adapter land, but it isn't clear what.  

Thanks,

Hunter

Alexander Staubo wrote:
> 
> 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 )
> >