Forum Discussion
FernandoTropico
Aug 04, 2021Copper Contributor
Is ODBC worth updating?
Hi guys. I am new to the community. SQL DBA in Townsville, Australia. We've moved mostly away from ODBC connections and over to PowerQuery, via DirectAccess or Import on our reports and Sharepoint l...
AnatoliD
Aug 13, 2021Copper Contributor
The last is correct - PowerQuery is using ODBC.
PowerQuery can use ODBC, OLEDB, ODATA, etc
ODBC driver is being updated mostly for interaction with Azure services:
https://docs.microsoft.com/en-us/sql/connect/odbc/windows/release-notes-odbc-sql-server-windows?view=sql-server-ver15
Unless you have a specific problem - you don't really need to update it.
PowerQuery can use ODBC, OLEDB, ODATA, etc
ODBC driver is being updated mostly for interaction with Azure services:
https://docs.microsoft.com/en-us/sql/connect/odbc/windows/release-notes-odbc-sql-server-windows?view=sql-server-ver15
Unless you have a specific problem - you don't really need to update it.
- FernandoTropicoAug 13, 2021Copper Contributor
AnatoliD Awesome! Thanks for the clarification.