[Zope-DB] Access and Zope in Linux 7.2

Robert Kellock sales@creditscore.co.nz
Thu, 13 Mar 2003 11:11:42 +1300


--=====_104750710241=_
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable

>> On 2003-03-12 at 15:35:31 [+0100], Bennett Fonacier wrote:
>> > Hello zope gurus,
>> >
>> > I have a Zope 2.6 running on Linux 7.2.  I have another computer with
>> > Win2K and an Apache and PHP.  What I would like to do is run Access on
> > the win2K but Zope accessing the database.  Is this the best
>> > configuration?  Do I need to install Zope with Apache and PHP on=
 Win2K?>
>> You just need to set up Access and ODBC on Win2K and use mxODBC on the
>> Linux machine to talk to it. No Apache, no PHP.

> If you cant get other option to work this one 
> (http://www.zope.org/Members/zorton/zope_linux_to_mssqlserver), is a hard=
 
> kung-fu but you should be able to put this to work with MS Access also.

Or try isectZope (http://www.zope.org/Members/creditscore/isectZope). It's=
 cross-platform and very lightweight,  whereas the server component of=
 SQLRelay only works on the Unix variants. isectZope contains a generic=
 Zope DA and Visual Basic bindings and comes with Windows binaries. To make=
 it work with MS-Access all you will need to do is create a small VB EXE=
 that connects to Access using DAO or ADO and ships the result set back to=
 Zope as a Python eval() capable string.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Robert Kellock
Sales Manager
Credit Systems Control Ltd
Ph: 64 3 3266115
www.creditscore.co.nz

'making decisions easy'
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D


--=====_104750710241=_
Content-Type: text/html; charset="us-ascii"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.2614.3500" name=GENERATOR></HEAD>
<BODY bgColor=#ffffff style="FONT-FAMILY: Arial" text=#000000>
<DIV>&gt;&gt; <I>On 2003-03-12 at 15:35:31 [+0100], Bennett Fonacier 
wrote:<BR></I>&gt;&gt;<I> &gt; Hello zope gurus,<BR></I>&gt;&gt;<I> 
&gt;<BR></I>&gt;&gt;<I> &gt; I have a Zope 2.6 running on Linux 7.2.&nbsp; I 
have another computer with<BR></I>&gt;&gt;<I> &gt; Win2K and an Apache and PHP.  
What I would like to do is run Access on</I>&gt;<I> &gt; the win2K but Zope 
accessing the database.&nbsp; Is this the best<BR></I>&gt;&gt;<I> &gt; 
configuration?  Do I need to install Zope with Apache and PHP on Win2K?
</I>&gt;<I><BR></I>&gt;&gt; <I>You just need to set up Access and ODBC on Win2K 
and use mxODBC on the<BR></I>&gt;&gt; <I>Linux machine to talk to it. No Apache, 
no PHP.<BR></I><BR>&gt; If you cant get other option to work this one <BR>&gt; 
(<A 
href="http://www.zope.org/Members/zorton/zope_linux_to_mssqlserver">http://www.zope.org/Members/zorton/zope_linux_to_mssqlserver</A>), 
is a hard <BR>&gt; kung-fu but you should be able to put this to work with MS 
Access also.</DIV>
<DIV>&nbsp;</DIV>
<DIV>Or try&nbsp;isectZope (<A 
href="http://www.zope.org/Members/creditscore/isectZope">http://www.zope.org/Members/creditscore/isectZope</A>).&nbsp;It's 
cross-platform and very lightweight,  whereas the server component of SQLRelay 
only works on&nbsp;the Unix variants.&nbsp;isectZope contains a generic Zope DA 
and&nbsp;Visual Basic bindings and comes with Windows binaries. To make it work 
with MS-Access all you will need to do is create a small VB EXE that connects to 
Access using DAO or ADO and ships the result set back to Zope as a Python eval() 
capable string.<BR></DIV></BODY></HTML>

<BR>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.2614.3500" name=GENERATOR></HEAD>
<BODY bgColor=#ffffff style="FONT-FAMILY: Arial" text=#000000>
<DIV><FONT size=2>=====================</FONT></DIV>
<DIV><FONT size=2>Robert Kellock</FONT></DIV>
<DIV><FONT size=2>Sales Manager</FONT></DIV>
<DIV><FONT size=2>Credit Systems Control Ltd</FONT></DIV>
<DIV><FONT size=2>Ph: 64 3 3266115</FONT></DIV>
<DIV><FONT size=2><A 
href="http://www.creditscore.co.nz">www.creditscore.co.nz</A></FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=2>'making decisions easy'</FONT></DIV>
<DIV>
<DIV><FONT size=2>=====================</FONT></DIV></DIV></BODY></HTML>


--=====_104750710241=_--