I am presuming there's no option to return the drive and no one here can see exactly what you are seeing. If the connector body is broken but all the metal pins are intact, I suppose it's possible so attempt to secure it to the drive in some fashion and tie it to offer strain relief. Another option, if you are very good with a soldering iron might be to hard wire a cable to the drives interface. I've not cut one of these apart but I've been successful with remaking a USB-2 connector so I must think you can do it with SATA. You've got to be at a point with nothing to lose by trying. Good luck.