Agree...solder not going to help much, adhesives - depends, I've used adhesives which stick to metal like welding, but I doubt you have any access to those...I'd go with welding as said above. if you don't have access to welding I cant see any way out if not by up sizing the sprocket hole ( looking at the photo below you have more than enough space for that)