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

This post has been republished via RSS; it originally appeared at: Azure Database Support Blog articles.

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!

REMEMBER: these articles are REPUBLISHED. Your best bet to get a reply is to follow the link at the top of the post to the ORIGINAL post! BUT you're more than welcome to start discussions here:

This site uses Akismet to reduce spam. Learn how your comment data is processed.