Hi, I just installed INGRES on my window laptop but I noticed the
Remote Command does not start and display the error:

E_RE0006_STARTUP_RMCMD_OBJ Cannot access the RMCMD objects. The SQL
error code was -30100.

I tried the commands: "rmcmdrmv" followed by "rmcmdgen"

But on the second one I get the following error:

Create rmcmd objects failed: E_US100D line 1, Syntax error on '.'. The
correct syntax is: GRAN

I really don't know how to proceed , please help.

Many Thanks

Alessandro

Hello Allessandro,

Don't you have a dot (.) in your username ? Not sure Ingres like that very
much ...

1/ Your first error (E_RE0006) come from a lake of grant
2/ You have a lake of grant because rmcmdgen could not give it to your user

After a short look in source code (rmcmdgen.sc) :
- No grant mentionned in the source code (array affectation) have dot.
- The grant is modified by adding the user name (probably something like
%USERNAME% on W2K)
- Then the SQL is executed (EXEC SQL EXECUTE IMMADIATE stmt)
- and the message "Create rmcmd objects failed" is provided if return code
is not OK

Hope this help,
Jean-Pierre ZUATE
La Fage Conseil
+33(0)6 1140 1109

23 Oct 2006 01:24:04 -0700, aleazzone (AT) hotmail (DOT) com <aleazzone (AT) hotmail (DOT) com>:

Hi Jean-Pierre,
thanks for your answer, it is enlightening.

Is there any way in Windows to separate the Ingred account from the OS
one?

The problem is I do not have the administrator permission on my laptop
and it seems I am in a cul de sac, as I can't see any of the remote
command tables, views or procedures

Rgds

Alessandro

Jean-Pierre Zuate wrote: