Step 6: Test TPX database access
Step 6 tries to access information in the TPX database which you had selected in step 5. If this step fails, while the previous step (login to the TPX database) succeeds, there can be several possible causes.
(1) First, use the TPXAdmin program to see what is shown in the column 'Database version' (tab databases). If the database folder does not exist on the harddisk of the server computer, TPXAdmin will show 'Database folder not found' in the 'Database version' column. If one or more database files are missing or the database folder is empty, TPXAdmin will show 'Database file(s) not found'. If the entry in the column 'Database version' shows an older database version (with the suggestion 'please upgrade'), use menu⁄database⁄upgrade to version x.x.
(2) Secondly, also make sure that the TPXAdmin program you start, resides in the same directory (on your Windows server computer) as the currently active TPX database server program. To check whether the TPX database server program which is running, is the same as the tpxsrvr.exe which resides in the directory of the tpxadmin.exe program, please look at the statusbar of the TPX database server program. It will show the full path of its executable file.
(3) Third, click on the tab 'Table management' in the TPXAdmin program, and perform a 'verify' of the database. Depending on the nature of the error message, the function 'repair' will correct the problem reported.
(4) The TPX database alias selected in step 5 might point to a non-existing directory on the server or a directory not containing TPX database files. If this is the case, use TPXAdmin on the server to point the database alias to a correct directory.
(5) The .scf configuration file in the directory of TPXSRVR.exe is not readable.
The configuration might have been encrypted⁄created on a different computer. It is not possible to copy a .scf configuration file from one computer to another computer.
If you suspect that this is the case, perform the following steps in this exact order:
- stop TPXSRVR.exe
- rename or delete the .scf file in the directory of TPXSRVR.exe
- restart TPXSRVR.exe
- reconfigure TPX (define databases, users, etc.) using TPXAdmin.exe
- restart this diagnostics program and⁄or TPXClient');
(6) You might have accidentally installed TPX Server on two or more locations on your server computer. The TPX Server which is currently running uses an outdated tpxsrvr.scf configuration file. It might contain database aliases which point to non-existent directories.
Open TPXSRVR from its system-tray icon, and check the path of the currently running TPXSRVR.exe in the statusbar.
When all the diagnistics steps (as listed in this article and the previous five articles) succeed, all problems are solved, and the user should be able to connect to the remote database with the tested username⁄password using the TPX client program.