[Zope] Problem with ZODBCDA-3.1.0b2
Alexander Staubo
alex@mop.no
Fri, 1 Oct 1999 07:18:36 +0200
Here's a suggestion that I didn't think of earlier: Enable logging in
the ODBC Administrator control panel. For example, you might get things
like:
z2 d2:4f EXIT SQLConnectW with return code -1
(SQL_ERROR)
HDBC 0x01306828
WCHAR * 0x01303478 [ 8] "Foobar"
SWORD 8
WCHAR * 0x6a9ac284 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x6a9ac284 [ -3] "******\ 0"
SWORD -3
DIAG [S1000] [Microsoft][ODBC Microsoft Access 97
Driver] Can't open database '(unknown)'. It may not be a database that
your application recognizes, or the file may be corrupt. (-1028)
...which is exactly what I'm getting with a certain Access database I'm
trying to set up.
(A curse on Access! But sometimes that's what a customer wants, alas. A
curse on customers!) This information may help you determine what the
problem is.
--
Alexander Staubo http://www.mop.no/~alex/
"`Ford, you're turning into a penguin. Stop it.'"
--Douglas Adams, _The Hitchhiker's Guide to the Galaxy_
> -----Original Message-----
> From: Hunter Kelly [mailto:retnuh@oniva.com]
> Sent: 30. september 1999 13:29
> To: Alexander Staubo
> Cc: Zope Mailing List (E-mail)
> Subject: Re: [Zope] Problem with ZODBCDA-3.1.0b2
>
>
> 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 )
> > >
>
> _______________________________________________
> 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 )
>