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 )