668 System command cannot be executed - 1: Not owner
Gavin Rifkind's stored procedure runs a system command to call a 4GE program; it works from DBAccess but via JDBC (also SQuirreL) fails on some client computers with error 668 and ISAM error 1 (Not owner). kjuliff asked how the client connects to the SE host and whether it logs in to the host. Gavin explained it connects over TCP/IP. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Good Day
I have the following problem which I would appreciate some help with
I have a Stored Procedure which executes a System command to call a 4GE
program.
When executing the stored procedure directly on the server using
DBACCESS,
everything works correctly.
I have written a Java application which calls the Stored Procedure
using JDBC
The application works on some computers, but not on the others.
The error that it gets is "668 System command cannot be executed" and
ISAM erroris "1 Not Owner".
Both computers are using the same login credentials, and the same
version of the
JDBC drivers.
The executable 4GE has execute permissions for all users.
I also have similar results trying to execute the Stored Procedure with
other
JDBC clients eg. SQuirreL SQL. It works on some computers but not
others.
Please can somebody point me in the right direction.
Thanks
Gavin Rifkind
--
gavinrifkind
------------------------------------------------------------------------
gavinrifkind's Profile: http://www.dbtalk.net/m553
View this thread: http://www.dbtalk.net/t320415
How are you connecting to the machine running SE? I'm accuming over a newtork. What is the ralationship between the calling program's machine and the host?
I am connecting over a network using a JDBC driver which uses tcp-ip to connect to the server. I am not sure what you mean by "the relationship" between the client and the host -- gavinrifkind ------------------------------------------------------------------------ gavinrifkind's Profile: http://www.dbtalk.net/m553 View this thread: http://www.dbtalk.net/t320415
Dous it "login" to the host? gavinrifkind wrote: > I am connecting over a network using a JDBC driver which uses tcp-ip to > connect to the server. > I am not sure what you mean by "the relationship" between the client > and the host