I just started working on an application that uses Cache, and so far,
I have not been able to get either SQL Manager to connect or to
establish
an ODBC connection to any Cache namespace.

I am not sure which version the database is, but the Cache client is
5.0.3.
Cache Control Panel does work OK, and I can see processes and
namespaces.

When I try to connect with SQL Manager, I get an error
"Failure to create %SQLAPI. <NOROUTINE>9^%CDSrv0"

ODBC returns errors stating that either Cache is not running on port
1972
or that I have the wrong userid/password.


Is there a userid that is created during installation, like
system/manager
with Oracle?

The application uses Knowledge Based Systems KB-SQL on top of Cache.
My
real goal is to be able to look at SQL tables, views, etc that I will
access via KB-SQL. I am not even sure that having SQL Manager will
help with that.
At this point, I don't have a database design doc, and I have minimal
information about the actual database structure. Are there any
catalog
tables or something similar that I can look at to determine the the
structure
of tables, views, indexes, etc?

tia,
Bill

Bill

There are two seperate aspects here: your unability to connect with
the Caché 5 client tools to the backend and your wish to use Sql
Manager to look at your KB/Sql tables.

1. Do you know which version your Caché server is? Can you get to the
programmer prompt via a terminal / telnet session? If so, type W $ZV
(or Write $ZVERSION) which should return the version and build number.
It's possible that your version is <3 in which case there was no
server process on port 1972 and there was a previous generation of
client tools (but no Sql Manager). The default odbc server process
port was 5001 but you had to start the server process via the
Configuration tool. If it turns out that you are on a recent version
of Caché then it's possible that the system manager has moved the
"super server" from its default location on port 1972 to another port
which would explain your odbc access problem but not the routine
crash.

2. You can't mix KB/Sql and Caché Sql. Kbase is an sql tool for
M(umps) implementations which allows you to map M global structures to
relational tables. You can use it in Caché as Caché is a superset of
good old M but since v3 Caché has its own built in Sql support that is
linked to Caché Objects with its own mapping to the underlying
globals. Haven't you got access to the KB/Sql client tools?


Wolf Koelling

bill_sheets (AT) hotmail (DOT) com (Bill S.) wrote in message news:<74600c03.0405240537.11130e07 (AT) posting (DOT) google.com>...

wolf.koelling (AT) slaughterandmay (DOT) com (Wolf Koelling) wrote in message news:<eef28651.0405250740.6308f0ad (AT) posting (DOT) google.com>...
The version I am connecting to is:

Cache for UNIX (Linux Intel/32-bit)
5.0.3 (Build 720) Tue Jul 22 2003 15:30:29 EDT

I did check 2 systems running Cache, and both have a process listening
on port 1972.

Since I posted, I found the CD for KB-SQL which had the DBA manual
and some other docs I was missing, plus the ODBC driver & QRE. Now
my goal is to get the ODBC driver for KB-SQL to connect so I can
use QRE to look at the data and write queries.

It looks like the TCP port configuration for KB-SQL was not set up,
so the ODBC driver will not connect. I am working through that now.

Getting Cache's SQL Manager to work would be nice, but chances are
that like you said, I really do not need it for my tasks. It is
more of an annoyance that something is not working.

-Bill