.netpowershelldsn

How do you programmatically create a System DSN using Powershell or .NET?

How do you create a System DSN in the control panel on ones PC using Powershell or .NET?

Solution

  • This can be done with some registry edit. Refer this link:

    http://derek858.blogspot.com/2010/02/create-32-bit-system-dsn-with.html

    Note that for 64-bit you will be using HKEY_LOCAL_MACHINE\Software\Odbc\Odbc.ini\