I need to change my ODBC data source MS Access file frequently during debugging.
Manually, the step is to open ODBC Data Sources, select the (existing) DSN, configure, select the .mdb file on disk. Close.
I'd like to do this via a script (Powershell, Batch, ...) where i'd provide the DSN and file path on the command line. What options do i have to set the ODBC data source from Powershell for example?
Set-OdbcDsn
, Set-OdbcDsn. – AdminOfThings