Joe great article.
I used this to configure the Generic SQL Connector v1.1.1170.0 to connect to an Oracle SQL instance using the Instant Client and ODBC driver x64 v19.6.0.0.0 (https://www.oracle.com/uk/database/technologies/instant-client/winx64-64-downloads.html) which worked great as I didn't have a copy the full Oracle client.
With this configuration adding the system variable NLS_DATE_FORMAT caused the ODBC administrator to crash when clicking Test Connection on a new and configured DSN and also caused the MIM Sync Service to stop. Once the NLS_DATE_FORMAT system variable was removed both ODBC administrator and the MIM sync service worked as expected. The event viewer error message details for the ODBC administrator crash:
Faulting application name: odbcad32.exe, version: 10.0.17763.1, time stamp: 0x8009592a
Faulting module name: VCRUNTIME140.dll, version: 14.22.27821.0, time stamp: 0x5d0c182d
Exception code: 0xc0000409
Fault offset: 0x0000000000001900
Faulting process id: 0x2678
Faulting application start time: 0x01d629db61b57c9a
Faulting application path: C:\Windows\system32\odbcad32.exe
Faulting module path: C:\Windows\SYSTEM32\VCRUNTIME140.dll
Report Id: dbddc4fc-2042-4d46-b5df-48d2fd5d4b44
Faulting package full name:
Faulting package-relative application ID:
Microsoft
