[Zope] MSAccess

[Loren Stafford]

I presume you meant "... and access it with Zope on another _Win2K_ server."

This is possible. The Zope part is straight-forward. I do this on WinNT4
using the ZODBC driver. I don't know if Win2K is different, but I wouldn't
expect so. You have to set up a system DSN for the database, not a User DSN.
The tricky part is getting the Win2K permissions set up correctly. We spent
some time experimenting with different combinations. We created a special
user, ZopeServer. The Zope instance runs as user ZopeServer. IIRC (and here
I'm not sure), ZopeServer has to have Local Admin privileges on the DB host.
(But last time I said this on the list, someone wrote that they were doing
it successfully with a less elaborate configuration. Clearly, no one can
give you a cookbook recipe for this -- you have to have a consistent Win2K
security strategy.)

Anyway, when you say "nothing works", you won't get much help unless you
give details of configuration and error messages.

-- Loren

> -----Original Message-----
> From: Schmidt, Allen J. [mailto:aschmidt@nv.cc.va.us]
> Sent: Monday, July 02, 2001 09:39
> To: 'Chris Withers'; Loren Stafford
> Cc: Montagne, Michael; zope@zope.org
> Subject: RE: [Zope] MSAccess
>
>
> ...and still....
> I have been trying to find a way (should work, but doesn't) to have an
> Access on one Windows2000 server and access it with Zope on
> another server.
> Lost of suggestions ... nothing works.
>
> Waiting patiently in the wings...
>
> Allen
>
> -----Original Message-----
> From: Chris Withers [mailto:chrisw@nipltd.com]
> Sent: Monday, July 02, 2001 12:08 PM
> To: Loren Stafford
> Cc: Montagne, Michael; zope@zope.org
> Subject: Re: [Zope] MSAccess
>
>
> Loren Stafford wrote:
> >
> > While I've read on this mailing list that there are some Linux ODBC
> drivers,
> > I have no experience with them. What I do is run a Zope installation on
> one
> > of the Windows machines, which can access the MSAccess DB with
> the Windows
> > ODBC. Then the Linux Zope gets the data from the Windows Zope using some
> > form of RPC, such as Client.py
> > (http://www.zope.org/Members/lstaffor/ZClientMethod) or XML-RPC (which I
> > have not tried).
>
> We need something similar, so we're going with a ZEO setup with
> the storage
> server and the web-serving client on a Linux box and another ZEO client
> running
> on a Windoze box doing what it needs to...
>
> cheers,
>
> Chris
>
> _______________________________________________
> 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 )
>