Q1: In order to troubleshoot a network environment, we first need to know what is wrong. Every database call returns a numeric Status Code, with 0 indicating success. Any non-zero number will help determine the source of the problem.
If you are NOT getting a valid status code back, then we will need to find one first. Luckily, we can use the PSQL Function Executor to perform some tests.
First, open the PSQL Function Executor on the client workstation. In the File/Open dialog box, browse to one of your database files. (You may need to change the "Files Of Type" to All Files to see some other extensions.)
When you click Open, you will get either a large dialog with lots of numbers that indicates you were successful, or you will get a numeric status code back.
If you got a numeric status code, enter it here. If you did not get an error, then your database environment is actually fine, so you should instead contact the application developer for additional help.
If you need additional help with Function Executor, check out our
white paper on the topic.