668 System command cannot be executed - 1: Not owner
Posted in 2006
Topics: Stored Procedures & SPL, Error Codes & Troubleshooting, Connectivity: ODBC / JDBC / .NET, Server Administration, Java & JDBC Development
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