Issues with tilt adapter on D5100

Hello, I just got this tilt adapter off eBay for my D5100: Tilt Nikon F Lens Mount to Sony NEX E NEX 3 NEX 5 NEX 3c Camera Mount Adapter | eBay. I ordered one for a Nikon lens to a Sony NEX mount because I only have Nikon lenses and I know that Sony's NEX mount is very close to the Nikon F. Close enough for it to fit securely without damaging anything and with the locking pin able to lock the lens/adapter in. I have a ƒ/2.8 28mm Albinar on the lens adapter which is on the camera and cannot get anything to focus. I've tried it at different tilt angles (0-8) and have had no luck. Everything is just blurry. It kind of gives the effect of a macro extension bellow between the lens and body. I really would love to be able to get the tilt shift effect to work. If anyone could help, it'd be greatly appreciated. Thanks!