Ok..probably one of the dumbest things I have done but bare with me!

I just bought my new speed sensor because my old one had the pin in the middle corroded off. I installed it in a parking lot because I couldn't wait til I got home to see how fast I was going. The first time I installed it the speed didn't rise so I figured it might have been the VSS along with something else e.x. bad ground, wiring etc. I pulled into another parking lot to see if everything was connected right, but as I get ready to re-install it again, I bolt down the part that bolts down to the tranny to hard and the metal piece snapped in half. The weird thing is that the bolt I was tightening down didn't even feel as if it were tightened yet, that is why I kept going. Also, when I snapped the metal piece it snapped the plastic part that bolts on top of the piece that goes into the tranny. I figured since the plastic part is only there to help hold it to the metal part that I would be fine, considering there is another plastic part that helps hold it to the part that goes into the tranny. My only BIG screw up is basically the metal part that bolts into the tranny. Any way to fix it? Or what is it called, so I can look for it at Acura. I was going to see if someone could weld it, but the rep. at autozone said that piece wouldn't be able to get welded back. Oh I did use JB Weld, but that doesn't seem very reliable. And about the plastic thing breaking, am I a total lost at that? Or since it just holds it is it ok that one piece broke? Also, when I broke the metal piece and the VSS just moved around freely the speedometer worked, but jumped ALOT. Why is that? And when I installed it first without it breaking the speedometer moved NOWHERE!

Thanks in advance for any replies!

By the way car is a 98 Integra LS