While I have known for some time that Windows stores registry keys in different locations based on the application being 32 or 64 bits today I also discovered that for Services the SpecialFolder.ApplicationData folder is also different.
A 64bit Service will see the application data at
while a 32bit Service will see the data at
The native path of both however will appear to be
C:\\Windows\\System32\\config\\systemprofile\\AppData\\Roaming\\ when using the folder item native path.
In the registry you’ll find an added WOW6432Node layer.
32bit ODBC is
while 64bit is
Windows automagically maps these settings for 32 bit apps on 64bit OS’s.