[Zope] Problem with ZODBCDA-3.1.0b2

Chui Tey Chui.Tey@env.qld.gov.au
Fri, 01 Oct 1999 16:02:39 +1000


If you received the Access file from someone else, chances is it is
actually an Access2000 file. That requires JET4 drivers and Access97
(running jet 3.51) will not cut it. I suggest you download the MDAC
(huge file!) from http://www.microsoft.com/data and that should give you
the JET4 drivers you need.

Regards,

Chui

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