668 System command cannot be executed - 1: Not owner

[gavinrifkind]

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 error
is "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

 

[mishradd]

Did you check the finderr 668 code, check following points

1. Make sure that the system command is not trying to run something that is not in your path or that is not applicable to the environment.
2. Make sure that you have provided a user-id and password when connecting to the database server. The database server must have the user's password in order to execute a command on behalf of that user.
3. your procedure should have execute permission for that user.

hope this helps