Stored procedures between 2 database servers

I have two database servers A (HP-UX) and B (NT) I execute a stored procedure in server B, this procedure calls a Stored procedure in A, the procedure in A does a select of a table in server B, the system gives me this error: 556: Cannot create, drop, or modify an object on an another database serverWe know this error, but we don't create, drop or modify something, it's only a select clause, This have worked well a week ago, before reinstall the database server A. Nothing has changed. What occurs? Please help. Miguel Angel Ferrer EOS Inform'tica S.A.L. m-ferrer.eos@ctv.es

> I have two database servers A (HP-UX) and B (NT) > I execute a stored procedure in server B, this procedure calls a Stored > procedure in A, the procedure in A does a select of a table in server B, the > system gives me this error: > 556: Cannot create, drop, or modify an object on an another database server> We know this error, but we don't create, drop or modify something, it's only > a select clause, > This have worked well a week ago, before reinstall the database server A. > Nothing has changed. What occurs? We trapped into the same error after updating one database server to a newer version (7.20 > 7.31). We got and Informix Case Number and they said to "unbug" this feature after! (not in) the next update. We got a little workaround: reduce the "connect-path" ! That means: 1. You connect to Server A 2. You connect to Server B (for executing the stored procedure) 3. You connect to Server A (for executing that stored procedure) 4. You connect to Server B (for selecting some data) Using more than 3 connects will result in the error you got. You could create the Stored Procedure on Server A ALSO on Server B and call that procedure from the first procedure locally. That will reduce your path for 2 connects and no errors. Hope that helps, Chris