I finally received the Kipon adapter for adapting Sony E-Mount lenses to the Nikon Z7. This is a DUMB adapter and works perfectly for allowing the Venus 100mm 2x APO macro to function, i.e. let's the shutter release fire. The TechArt TZE-01 would not let the shutter fire.
As for the lens itself, very short focus throw which is terrible for the close focus that 2x requires. I will keep it for use on very close insect shots, but if I stack anything, I will have to put it on a focus rail. Otherwise the Venus/Laowa 100mm F/2.8 2X Ultra Macro APO Lens for Sony FE seems to work OK. Will check it out.
Sample photo with the Laowa 100mm focused on the very tip of the top. Not too bad, eh?