Note that ZSybaseDA has a bug that keeps it from publishing errors correctly. Check the line number given in the traceback. Verify that you login ID has access to the database and table. You can test this manually thus (replace user name, password, server and database with real values): import ctsybase c = ctsybase.ctsybase({'user': 'bob', 'password': 'bob', 'server': 'MYSYB'}) c.execute('use my_database') which should go through okay if it works, give you a (hopefully) human-readable error response if not. -- Alexander Staubo http://www.mop.no/~alex/ "Give me an underground laboratory, half a dozen atom smashers and a beautiful girl in a diaphanous veil waiting to be turned into a chimpanzee, and I care not who writes the nation's laws." --S. J. Perelman -----Original Message----- From: A J Wilson [mailto:ajwilson@ezy.net.au] Sent: 25. juli 1999 22:33 To: zope@zope.org Cc: rossl@med.usyd.edu.au Subject: Re: [Zope] How to connect to Sybase using ZSybaseDA I have a Sybase database which I can access through isql, MSAccess, Sybase Central etc. When I tried to access it using the ZSybaseDA using the connection string in the form [dbusername] [password] [machinename] [databasename] I get an error saying "Invalid connection string:". Any other suggestions. Regards Austin
From: rossl@med.usyd.edu.au Date: Sat, 24 Jul 1999 18:14:06 -0700 To: zope@zope.org Subject: Re: [Zope] How to connect to Sybase using ZSybaseDA
try [dbusername] [password] [machinename] [databasename]
eg
bob bobspass redhat1 zopestuff
(Of course, you need to use the sybase utilities to make database zopestuff and accessible by bob using bobspass)
<003001bed623$61e130a0$0202a8c-@lalaland.net.au> wrote: o>riginal article:http://www.egroups.com/group/zope/?start=8450 Hi
I managed to compile the ZSybaseDA under Redhat 5.1. Now I need help to connect to the database. Zope is running on the same machine as Sybase ASE. Could someone please tell me the format for the Database Connection String?