Sybase ASE on NT

[Whittall, Conrad]

Hi Steve,

According to the PDL Reference Manual in the current PowerHouse Books 1.2
documentation set, the format for the OPEN clause of the DATABASE statement
when referring to a Sybase database is:

     <database physical name>@userid/password

Hence for your database I would expect the following:

     database billing type sybase &
         open FRANKLIN_12ASE@billing/sa

...assuming that FRANKLIN_12ASE is the name that you have configured your
Sybase Open Client software to recognize this database by.

I note that you say that you have created a DSN for this database...which
suggests to me an ODBC connection rather than a Sybase Open Client
connection. PowerHouse and Axiant do not support ODBC access to Sybase ASE
(only Sybase ASA, formerly known as SQL Anywhere).

Best regards,
Conrad

Conrad Whittall
Marketing Manager, Application Development Tools
Cognos Incorporated, 3755 Riverside Drive, Ottawa, Ontario, K1G 4K9, Canada

-----Original Message-----
From: Steve Franklin [mailto:steve_franklin@yahoo.com]
Sent: Thursday 12 July 2001 13:56
To: powerh-l@lists.swau.edu
Subject: Sybase ASE on NT


Is anyone using Sybase ASE version 12 on an NT or Windows 2000 platform?  I
am trying to get both Axiant version 3.0 and Powerhouse 8.21D4 for NT to
work with Sybase.  Any help would be appreciated.  I have a database that I
can create a DSN for and connect to.  I can also issue SQL commands directly
to the database.  Therefore, I assume the database is fine.  I created a
dictionary in PDL with the following:

cancel clear
create dictionary test
database billing type sybase &
   open FRANKLIN_12ASE|billing@sa/
load

FRANKLIN_12ASE is the name of my server.  Billing is the name of the
database.  SA is the user name without a password.

I tried to access the file in quiz using bl_employees in billing.  I get an
error.  I tried a "show database" inside quiz and I get an error "*E* SQL
Access error (BILLING)". Obviously, there is a problem with accessing the
database.  I do see references to the system tables from what I assume is
the master database.

Any suggestions are greatly appreciated.


Steve Franklin
Stw Inc.
952-432-2203
Email: steve_franklin@yahoo.com