Hello everyone,
Do you know if Uniface 9.7.04 is compatible with MSS 2019/2025?
Compatibility in PAM is up to MS SQL Server 2016.
Do you know if it's possible to configure the database on SQL Server 2025 by forcing the backward compatibility level (e.g., setting the level to 130 for SQL Server 2016 or 140 for 2017, which were supported by the Uniface 9 subversions) and if any issues have been encountered?
Thanks,
Alessandro
+1Hi Alessandro,
Officially, no. The PAM for 9.7.04 stops at SQL Server 2016, and 9.7 has been out of support since December 2020. Rocket only certifies newer SQL Server versions (including 2025) on the current runtime, which is 10.4 — they don't add database support to older Uniface versions.
+1On the compatibility level idea: it won't really help. Setting the database to 130/140 only changes the query optimizer and T-SQL behavior, not the driver, TDS protocol or encryption — and that connection layer is where 9.7.04 tends to break with newer SQL Server
Thanks Juliano,
I've verified that the drivers work correctly with MSS 2019 (I just need to read data from some tables from another application). From anyone's experience, do you know if the drivers also work with MSS 2025?
Thanks,
Alessandro
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
