Creating a new system DSN: "Faulting application odbcad32.exe, version 3.526.3959.0, faulting module unknown, version 0.0.0.0, fault address 0x5bb312de"
This is an issue that I have seen a few times, so it could be worth mentioning.
The error is as follows:
When trying to create a new System DSN using the ODBC Data Source Administrator, the odbcad32.exe process goes down.
And you will see something like this in the event viewer:
Event Type: Error
Event Source: Application Error
Event Category: (100)
Event ID: 1000
Date: ...
Time: ...
User: N/A
Computer: [computer name]
Description:
Faulting application odbcad32.exe, version 3.526.3959.0, faulting module unknown, version 0.0.0.0, fault address 0x5bb312de.
For more information, see Help and Support Center at https://go.microsoft.com/fwlink/events.asp.
Data:
0000: 41 70 70 6c 69 63 61 74 Applicat
0008: 69 6f 6e 20 46 61 69 6c ion Fail
0010: 75 72 65 20 20 6f 64 62 ure odb
0018: 63 61 64 33 32 2e 65 78 cad32.ex
0020: 65 20 33 2e 35 32 36 2e e 3.526.
0028: 33 39 35 39 2e 30 20 69 3959.0 i
0030: 6e 20 75 6e 6b 6e 6f 77 n unknow
0038: 6e 20 30 2e 30 2e 30 2e n 0.0.0.
0040: 30 20 61 74 20 6f 66 66 0 at off
0048: 73 65 74 20 35 62 62 33 set 5bb3
0050: 31 32 64 65 12de
The important thing here is the address: 0x5bb312de
Now, above I mentioned that you get it when creating a new DSN, but a quick look around shows that it may happen for other applications as well.
Basically this happens on a Citrix machines, and the reason is that the ‘Citrix Virtual Memory Optimization’ service is set to ON.
This sometimes causes an Access Violation at this address (0x5bb312de)
Turning off the ‘Citrix Virtual Memory Optimization’ service (CtxSFOSvc.exe) allows the DSN to be created.
Reference:
"Virtual Memory Optimization Feature"