Duct Tape will work for a while but once it rains the tape will loosen up. Call around for some convertible shops and see if they can repair it. The way it is now the water is going to slide down into your trunk or back seat where you definitely don't want it.
Good luck...