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
It happened again, i found the answer as soon as i mailed zope@zope.org The database connection don't like the * in select * from adatabase. As long as i can avoid a * it is ok Thank you Troy for pointing me to the tracing option in ODBC, something i didn't know about. Sorry for you all to disturb you, i really was looking at it for a long time (doing all the time the same things of course). Met vriendelijke groeten, Hans de Wit h.de.wit@scp.nl
participants (1)
-
Hans de Wit