[Zope] RE: SybaseDA

[Chris McDonough]

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