I don't know Paradox, but you might want to turn on error logging to help you. In WindowsNT, I select Data sources(ODBC32) under the control panel. Then, look at the tracing tab. That will let you turn it on. Troy -----Original Message----- From: Hans de Wit [mailto:hw@scp.nl] Sent: Friday, March 02, 2001 10:56 AM To: zope@zope.org Subject: [Zope] Paradox and zodbcda Hello, I am having problems with a Paradox database that is connected via odbc and the zodbcda into Zope. I tried it on two machines now and after a day or two the connection doesn't work anymore and i cann't revive it. Has anybody experience with connecting Paradox databases via ODBC into Zope (and give a hint). The symptoms are: When you test the database connection with a very simple SQL query: select * from atable The first time it gives back (this is my english translation of the dutch error message, stuurprogramma = driver / driverprogram?) Error Type: sql.error Error Value: ('S1093', -1003, '[Microsoft][ODBC Paradox-driverprogram] Invalid argument.') The second time that you issue the test it sends: Error Type: sql.error Error Value: ('24000', 0, '[Microsoft][ODBC-driverprogrammanagement] Invalid cursorstatus') Before i started the test the first time i was able to browse the database. All tables were shown. After the first test not anymore. Probably this is not a Zope error. The error messag is in dutch and Zope is in english. The messages hint that the problem is somewhere else. I was able to connect to the odbc source via Excel, even after the testing. Thanks Met vriendelijke groeten, Hans de Wit h.de.wit@scp.nl _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )