I've tried the ZJet adapter as well without luck. Go with the ZODB DA instead.
I've had a look at this product and installed it on Zope 2.8.7. It installed fine but when I look in the 'add' menu I'm not seeing an 'add ZJetDA database connection' which you get for other installed database adapters. Possibly I'm wrong in expecting this? I know it's totally crazy to want to hook Access up with Zope using sql queries but I'd just like to know if it's been done or is possible.
It works perfectly.
To connect to an MS Access DB on a windows machine you'll need to set the DB up as a system data source on the machine. This is done in the Start menu -> Administration -> ODBC datasources.
Add a system data source in there, and browse to your mdb file. Give the data source a name of your own choice, and when you go back into the zope manager and add the DB connection you need to write this data source name (DSN) in the connection string. After that your ZSQL methods will work perfectly.
Worked for me. I was forced to use an MS Access DB as well due to some very strict network policies about approved software for the network.
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )