[Zope] Sybase Connection Problems

[Chris McDonough]

Alexander,

First make sure that isql on the Zope machine (or Sybase Central/SQL
Advantage if you're running Zope on Windows) can connect to the remote
database you want to get to.  You may need to use dsedit in order to
configure the client to access the remote server.  Dsedit creates or
modifies a file named "interfaces" in the top-level sybase directory. 
This is where the port number config and other stuff ends up.  You'll
need a properly configured interfaces file to get the client stuff
connected to a remote database.

Once you've got isql working, go to Zope on the same machine and create
a database connection.  Fill in the server field with the DNS name or IP
address of the remote machine you've already tested with isql (no port
number), fill in username, fill in password, and fill in "datasource"
(it's the database name -- it will default to the "home" database of the
user which you log in as if you don't specify it).  You should be in
business then.

Alexander Schad wrote:
> 
> Hi folks,
> I got the SybaseDaV2 compiled and insatlled into zope. Now i`m trying to
> connect to a sybase 11.9.2 DB on a different machine and i`m not really
> sure about the correct syntax of the database connection string. Do i have
> to add the port number (4100) in the server field ??
> And what should be entered in the Datasource field ??
> Just the database name ?
> Could anybody give me an example of a valid filled Database Connection
> form ??
> 
>         Alexander Schad
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> 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 )

-- 
Chris McDonough
Digital Creations, Inc.
Zope - http://www.zope.org