Dan, It's gotta be a connection string or username/password problem as defined in your interfaces file. Are you sure the port number of the remote server is correct in the interfaces file? You can use isql from the box that Zope is on to connect to the remote Sybase server? -----Original Message----- From: Dan Zweifel [mailto:danz@vonhoffmann.com] Sent: Wednesday, March 15, 2000 2:43 PM To: 'Chris McDonough' Subject: RE: SybaseDA Chris First off let me say that I have searched the Zope archives. I finally got my sy_occ to compile and I have the SybaseDA Product installed(on Linux). When I try to add a new connection using the new DA I get the follwoing error. I have set up my interfaces file using dsedit and am using this as the DSN in Zope. Also I am trying to connect to a remote Sybase server. I am able to able to connect to the remote server using PowerBuilder ODBC on Windows. What am I missing? "Invalid connection string: database: sybase, password: generic, server: SYBASE, transactional: Y, user: generic Traceback (innermost last): File /usr/local/dc/Zope-2.1.4-linux2-x86/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /usr/local/dc/Zope-2.1.4-linux2-x86/lib/python/ZPublisher/Publish.py, line 179, in publish File /usr/local/dc/Zope-2.1.4-linux2-x86/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook File /usr/local/dc/Zope-2.1.4-linux2-x86/lib/python/ZPublisher/Publish.py, line 165, in publish File /usr/local/dc/Zope-2.1.4-linux2-x86/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_adddcSybaseConnection) File /usr/local/dc/Zope-2.1.4-linux2-x86/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: manage_adddcSybaseConnection) File /usr/local/dc/Zope-2.1.4-linux2-x86/lib/python/Products/SybaseDAv2/DA.py , line 100, in manage_adddcSybaseConnection File /usr/local/dc/Zope-2.1.4-linux2-x86/lib/python/Shared/DC/ZRDB/Connection .py, line 129, in __init__ (Object: RoleManager) File /usr/local/dc/Zope-2.1.4-linux2-x86/lib/python/Shared/DC/ZRDB/Connection .py, line 158, in edit (Object: RoleManager) File /usr/local/dc/Zope-2.1.4-linux2-x86/lib/python/Shared/DC/ZRDB/Connection .py, line 227, in connect (Object: RoleManager) File /usr/local/dc/Zope-2.1.4-linux2-x86/lib/python/Products/SybaseDAv2/db.py , line 147, in __init__ File /usr/local/dc/Zope-2.1.4-linux2-x86/lib/python/Products/SybaseDAv2/db.py , line 306, in _error BadRequest: (see above)" Thanks Dan -----Original Message----- From: Chris McDonough [mailto:chrism@digicool.com] Sent: Wednesday, March 08, 2000 9:57 AM To: Dan Zweifel Cc: 'support@digicool.com' Subject: Re: SybaseDA Dan, You need to install the Sybase client libraries on your Zope machine to use the SybaseDA. For more info, please contact the Zope mailing list at http://www.zope.org/MailingLists Thanks! Dan Zweifel wrote:
Good morning
I have a quick question for you. I am interested in using the
SybaseDA,
but from what I am reading in the Release Instructions, I must be running Sybase on my Zope machine. I want to be able to connect to a remote Sybase server, is this possible? If so, do I still need a working Sybase install on my Zope server?
Thanks in advance for your support
Dan Zweifel
-- Chris McDonough - Digital Creations, Inc. Publishers of Zope - http://www.zope.org