1

The SQL version compatibility BOL article advises that the minimum compatible JDBC driver version for SQL Server 2019 is 7.4.

Can an older JDBC driver still connect to SQL Server 2019? Or can only the driver versions listed as compatible connect to the specified SQL Server versions?

Improve this question
4
  • 3
    Have you tried it?...
    – Paul
    Apr 1, 2021 at 10:39
  • No, I get your point. But there is always a chance that I make a mistake in the implementation of my test which invalidates the result.
    – Pixelated
    Apr 1, 2021 at 10:41
  • 1
    But that's what testing is for - make a few tests up and give it a try.
    – Paul
    Apr 1, 2021 at 13:40
  • 'there is always a chance that I make a mistake in the implementation' ... Welcome to programming!
    – Paul
    Apr 1, 2021 at 13:46

1 Answer 1

Reset to default
0

Microsoft and my testing have confirmed that JDBC drivers not marked as compatible in the SQL version compatibility matrix might connect to a non compatible version of SQL Server and continue to work without issue.  

However, there is no guarantee that all functionality detailed in the Driver feature support matrix for Microsoft SQL Server is supported. They also only test the driver versions marked as compatible against the stated version of SQL Server.

JDBC version 4.0 was not specifically tested.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.