Use PowerShell to find DSNs

by Mitch Tulloch [Published on 30 July 2014 / Last Updated on 30 July 2014]

Learn how to use Windows PowerShell to find DSNs

Here's another tip from my colleague Ed Wilson (the Microsoft Scripting Guy) about how to use PowerShell to

Question: Your users are complaining about accessing specific legacy data sources. You want to see what DSN’s are defined on their Windows 8.1 desktop devices using Windows PowerShell. How can you do this easily?

Answer: Use the Get-OdbcDsn cmdlet from the wdac module. An example syntax appears here:

Get-OdbcDsn

Mitch Tulloch is a nine-time recipient of the Microsoft Most Valuable Professional (MVP) award and a widely recognized expert on Windows administration, deployment and virtualization.  For more information see http://www.mtit.com.

Ed Wilson is the bestselling author of eight books about Windows Scripting, including Windows PowerShell 3.0 Step by Step, and Windows PowerShell 3.0 First Steps. He writes a daily blog about Windows PowerShell call Hey, Scripting Guy! that is hosted on the Microsoft TechNet Script Center; for more PowerTips check out the Hey, Scripting Guy! blog.

See Also

Featured Links