Lesson Learned #149: Extracting data from Azure SQL DB using different drivers

by | Nov 30, 2020 | Azure, Microsoft, Technology | 0 comments

This article is contributed. See the original author and article here.

Today, I worked on a service request that our customer got an issue that depending on the driver that they are using they are not able to see data in a specific column. 


 


Sometimes, it is hard to debug the application or specify the driver to use to extract this data. In this Powershell command you could specify the driver and the provider to obtain this data.  


 


Basically, you need to define the parameter of the connection and the provider to connect. In terms of provider you could use


 



  • 1 – Driver: OLEDB – Provider: SQLOLEDB

  • 2 – Driver: OLEDB – Provider: MSOLEDBSQL

  • 3 – .Net SQL Client

  • 4 – Driver: ADO – Provider: SQLOLEDB

  • 5 – Driver: ADO – Provider: MSOLEDBSQL


 


Enjoy!

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.

Submit a Comment