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
participants (1)
-
Holger Lehmann