The following works with SpacePilot Pro, it's based on the old SDK code which doesn't work with the newer device, i.e. the wireless one.
dipdw.dwData = DIPROPAXISMODE_ABS;
I ended up merging the old with the new, first try init in old code, if failed then try init in new code. This works pretty well. It's all based on DInput, so no external dll is needed to go with the application (unlike 3DxWare SDK). Tested on SpacePilot, SpacePilot Pro, SpaceExplorer, SpaceNavigator (both original and SE), SpaceTraveller and SpaceMouse Wireless.
Post questions, comments and feedback to our 3Dconnexion Windows Development Team.