Help: problems with Intersystems Cache

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 S.) wrote in message ...
 > 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