The book "What is Mathematics?" by Courant and Robbins, despite its cushy-sounding name, would be my recommendation. First of all, it's written by two world-class mathematicians. Second, it's not a textbook; rather, it's what you might call a celebration of how awesome math is. If you want to succeed in college math without being miserable, why not try to see the subject as thing of beauty, rather than a burden? This book will definitely help you do that. If you read through the first half of the book (it shouldn't take long) you will have a chance to warm the math parts of your brain back up, and you'll learn some extremely cool shit along the way. (A bit of geometry, a bit of topology, a bit of algebra, etc.)
When you get to the authors' lucid explanation of the main ideas behind calculus, you'll realize that (1) calculus isn't scary, (2) the computations you need to learn how to do are fun, not hard, and (3) everything comes down to a few very intuitive ideas -- it may have taken geniuses like Newton and Leibnitz to come up with them in the first place, but they are part of our common intellectual heritage, not erudite ideas reserved for mathematicians and physicists.
And, although it's not a textbook, there are some exercises which will give you the chance to test your understanding. Again, though, they are fun, not grueling.