The problem is that it only works temporarily when I squish it with a couple of books.

Then I would posit that you've likely got another problem other than the crimp on the connector. Possibly the IDE header solder joints. Definitely look through all the items in the FAQ entry and check each possibility carefully.