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 )