Hi Thanks a lot for this. I'll try that out. Cheers. On 7/26/06, Jesper Steen Steffensen <jsteffensen@gmail.com> wrote:

Hi

...

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.

Thanks

michael

I've tried the ZJet adapter as well without luck. Go with the ZODB DA instead. 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 )

-- michael

Thanks a lot. Yes I know it's crazy but some organisations built up a database over the years and want to stay with that technology. The best way would be to migrate but I can understand why it doesn't happen. On 7/27/06, Philip Kilner <phil@xfr.co.uk> wrote:

Hi Michael,

michael nt milne wrote:

...

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.

Crazy on so many levels.../but/, although I can't tell you anything about the DA you are asking about, I can very strongly recommend the eGenix mxODBC DA - using that product, it is possible, and does work.

--

Regards,

PhilK

"Human language continually changes, innit." - Stephen Juan

-- michael