How to get ODBC drivers using Powershell

22 January,2020 by Jack Vamvas

Question: I had a question from a developer who was troubleshooting an application to SQL Server connection via a DSN using ODBC. They wanted the SQL Server ODBC Driver names and platform (32 bit|64 bit) used to connect . They will use this information to check application compatibility . 

Odbc

Although i can just RDP onto the server and grab the information through the ODBC gui - how can I use Powershell to get these ODBC details?

Answer: You can extract the ODBC Driver name and platform via the Powershell cmdlet - Get-OdbcDriver.

There are various options including to run the cmdlet locally and extract the information from a remote server

Here is an example of the Get-OdbcDriver. This example connects to a remote server and returns the details for odbc drivers with "sql" in the name placing them in a formatted table

 

Get-OdbcDriver -CimSession MyServer -Name *sql* | Format-Table name, platform -AutoSize
name platform
---- --------
SQL Server 32-bit
SQL Server Native Client 11.0 32-bit
ODBC Driver 13 for SQL Server 32-bit
SQL Server 64-bit
SQL Server Native Client 11.0 64-bit
ODBC Driver 13 for SQL Server 64-bit
SQL Server Native Client RDA 11.0 64-bit

 

 


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on How to get ODBC drivers using Powershell


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer