I didn’t do a DIY fix, I’ve taken mine to a convertible top place for two issues. But I think this is the stuff most places tend to recommend:
https://www.amazon.com/3M-08609-Wind...ct_top?ie=UTF8
First issue: Was 3 or so years ago now. The fabric was detaching below the window, as noted in the thread. Wasnt exactly a showroom finish, but its still holding fast, several years later. My car also lives outside (no garage), and has snow on it over the winter, etc. So, that fix was pretty badass. Dont recall the cost though.
Second issue: This summer the rest of the adhesive was letting go around the top and sides (arg!), brought it to another place more local, and he sealed it back up. Thus far, its been holding up well. Cost me $200.
Unfortunately, neither of these guys were particularly forthcoming in HOW they got it to stay, but my point is - if you can find a local convertible specialty place, they may be willing to help and it might hold on for you for several years.