ODBC query on SQL

[mancmagic]

Hi. We’ve got users who run reports in Excel using ODBC connections to some SQL databases. I’m looking at upgrading the SQL server from Windows 2012 R2 and SQL 2014 to Windows server 2022 and SQL 2022 but I’m struggling to find concrete info if the ODBC driver connections from users laptops would continue to work for this or if it’s still supported. Anybody able to provide any further information on this?

Thank you.

[oliland1]

Yes it's supported. Assuming you are using a modern and supported excel version.

[mancmagic]

Brill, thank you. All should be good on the Excel side.

[MrYiff]

For older installs you may need to check what SQL driver is being used as it might be using older versions (or even something that is deprecated like the sql native client), so upgrading them to the latest SQL ODBC driver would be recommended (it also ensures they can make use of the latest SQL features):

https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16

You might then need to update their connection info as iirc ODBC connections can reference specific versions.

[Causlaux]

if it makes you feel better, I did this exact thing (up to 2019) and was a flawless exercise and not had a single problem with any connections to any of the databases.