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

Published 11-30-2020 11:17 AM 996 Views

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!

%3CLINGO-SUB%20id%3D%22lingo-sub-1941798%22%20slang%3D%22en-US%22%3ELesson%20Learned%20%23149%3A%20Extracting%20data%20from%20Azure%20SQL%20DB%20using%20different%20drivers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1941798%22%20slang%3D%22en-US%22%3E%3CP%3EToday%2C%20I%20worked%20on%20a%20service%20request%20that%20our%20customer%20got%20an%20issue%20that%20depending%20on%20the%20driver%20that%20they%20are%20using%20they%20are%20not%20able%20to%20see%20data%20in%20a%20specific%20column.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESometimes%2C%20it%20is%20hard%20to%20debug%20the%20application%20or%20specify%20the%20driver%20to%20use%20to%20extract%20this%20data.%20In%20this%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FJMNetwalker%2FRetrieveAndCheckData%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EPowershell%3C%2FA%3E%20command%20you%20could%20specify%20the%20driver%20and%20the%20provider%20to%20obtain%20this%20data.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBasically%2C%20you%20need%20to%20define%20the%20parameter%20of%20the%20connection%20and%20the%20provider%20to%20connect.%20In%20terms%20of%20provider%20you%20could%20use%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CSPAN%3E1%20-%20Driver%3A%20OLEDB%20-%20Provider%3A%20SQLOLEDB%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3E2%20-%20Driver%3A%20OLEDB%20-%20Provider%3A%20MSOLEDBSQL%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3E3%20-%20.Net%20SQL%20Client%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3E4%20-%20Driver%3A%20ADO%20-%20Provider%3A%20SQLOLEDB%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3E5%20-%20Driver%3A%20ADO%20-%20Provider%3A%20MSOLEDBSQL%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EEnjoy!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1941798%22%20slang%3D%22en-US%22%3E%3CP%3EToday%2C%20I%20worked%20on%20a%20service%20request%20that%20our%20customer%20got%20an%20issue%20that%20depending%20on%20the%20driver%20that%20they%20are%20using%20they%20are%20not%20able%20to%20see%20data%20in%20a%20specific%20column.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESometimes%2C%20it%20is%20hard%20to%20debug%20the%20application%20or%20specify%20the%20driver%20to%20use%20to%20extract%20this%20data.%20In%20this%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FJMNetwalker%2FRetrieveAndCheckData%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EPowershell%3C%2FA%3E%20command%20you%20could%20specify%20the%20driver%20and%20the%20provider%20to%20obtain%20this%20data.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-TEASER%3E
Version history
Last update:
‎Nov 30 2020 11:17 AM
Updated by: