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.
If you are using Attaché version 25.1.1 or newer
If you have recently upgraded to Attache V25.1.1 or newer and are experiencing the error: '-20160 %s SP/T Feature not supported when updating Excel data using ODBC', see the points below:
You need to make sure that the Attache Server has Microsoft Visual C++ 2015-2022 Redistributable (x64) installed.
Otherwise, the Java component of Attache won't work and you will find an error in the CTSTATUS.FCS file: Unable to load JVM library ...\jvm.dll: system error 126.
The CTSTATUS.FCS file is located in the AttacheServer\Data folder.
You can download the file here: Microsoft Visual C++ 2015-2022 Redistributable (x64).
📌Note: the download file is a zip file, so you will need to extract it first, then double-click to run the installer.