You may experience this error when updating data via ODBC in Excel. To resolve this issue, you need to check ctsrvr.cfg file in the AttachéServer database directory and make sure the Java section is correct.
📌Note: you may need your Network administrator or IT support to do the steps below.
Locate your AttacheServer database folder. See: Find Attaché technical information.
On the server console, navigate to the AttachéServer folder, right-click on the ctsrvr.cfg file.
Right-click on the file and choose to copy and then paste to save a copy of the original file.
Once done, right-click the original ctsrvr.cfg file and choose Open With, Notepad.
Check this entry is in the file and is the same as below (where <ServerInstallDir> is the actual path of the database folder)
; JDK environment settings - Be sure to set the JDK to your version.
SETENV CLASSPATH=<ServerInstallDir>\Java\jre\lib\rt.jar;<ServerInstallDir>\Java\lib\ctreeSQLSP.jar
SETENV JVM_LIB=<ServerInstallDir>\Java\jre\bin\client\jvm.dll
SETENV JAVA_COMPILER=<ServerInstallDir>\Java\bin\javac.exeIf the <ServerInstallDir>
is not correct, change it to the actual path.
Check and update any other part of these 4 lines that are not as per above and save the changes to the file.
Check to see if the error still occurs.
If the error is still occurring, a re-installation of the AttachéServer will need to be performed, and this will fully re-create the ctsrvr.cfg file and contents. See: Install or upgrade Attaché Database Server.