[Zope] Re: Sybase in Remote Machine

[Holger Lehmann]

Hi Herbert,

I have no clues regarding sybase, sorry. I am using a MySQL database which
*can* run on the same or on a different host.

But have you checked if there is a new Sybase DA on zope.org ?
Furthermore, have you mailed this to the maintainer ? He/she might be
interested in that you want to connect to a remote host. Maybe you will get
what you want if you trigger the maintainter ... :-))

Can you switch to a different database ? If so, why not use MySQL or PostgreSQL
? Both are free to use (well MySQL costs a couple of bucks for commercial
purposes) and quite well supported.

- Holger

Am Mon, 24 Jul 2000 schrieb herbert@siliconcreation.com:
> Hello,
> 
> By using the SybaseDAv2.00b interface to input the database connection
> in the database@hostname format, I got this error: Invalid connection
> string.
> 
> And I checked the readme of the DA, it says "Ensure that you have
> Sybase installed on your machine,.." and "Set the environment variable
> ... to the Sybase installation directory on your local machine." Does
> iit imply that I have to put Sybase and Zope in the same machine?
> 
> 
> Regards,
> Herbert
> 
> 
> --- In zope@egroups.com, Holger Lehmann <lehmann@c...> wrote:
> > Hi,
> > 
> > you should be able to specify the hostname/IP-Adress in the
> connection string.
> > It should be similar (or the same) to the MySQL DA connection string
> I am using:
> > database@hostname user password
> > where hostname being the (correct !) hostname as being seen from the
> database,
> > i.e. I have to use the fqdn to connect since my MySQL server sees me
> with the
> > full domainname. Furthermor you have to set the access rights in
> your database
> > correctly for the user to be able to connect from that host ...
> > 
> > - Holger
> > 
> > Am Mon, 24 Jul 2000 schrieb Herbert Kwong:
> > > Hello,
> > > 
> > > I have SuSE 6.4, Zope 2.1.6, Sybase 11.9.2 and SybaseDAv2 in my
> > > machine.  It works fine.  However, is it possible to make my local
> > > Zope create a connection to a remote Sybase server?  As I would
> like
> > > to separate the Sybase Database from the Apache/Zope server. 
> Thanks.
> > > 
> > > Regards,
> > > Herbert Kwong
> > > herbert@s...
> > > 
> > > _______________________________________________
> > > Zope maillist  -  Zope@z...
> > > 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 )
> > -- 
> > -----------------------------------
> > catWorkX GmbH Hamburg
> > Dipl.-Ing. Holger Lehmann
> > Stresemannstr. 364
> > 22761 Hamburg
> > Tel: +49 40 890 646-0
> > Fax: +49 40 890 646-66
> > mailto:lehmann@c...
> > http://www.catworkx.de
> > http://www.catbridge.de
> > 
> > _______________________________________________
> > Zope maillist  -  Zope@z...
> > 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 )
-- 
-----------------------------------
catWorkX GmbH Hamburg
Dipl.-Ing. Holger Lehmann
Stresemannstr. 364
22761 Hamburg
Tel: +49 40 890 646-0
Fax: +49 40 890 646-66
mailto:lehmann@catworkx.de
http://www.catworkx.de
http://www.catbridge.de