Number one thing is tighten up your starting hand requirements. You can't bet people out of pots in limit, so you will need to have hands to win.
As far as the suited connectors, you can play them but only do it in bigger pots. The value of these hands is the draw, if it's only you vs one opponent the hand loses signifigant value. If you have three or four players in the pot before your turn you are getting good value to play that type of hand. Same goes for mid to low pocket pairs. Only mess with them if you are getting good odds
on the pot.
To sum things up, No limit is a game of psychology. You don't need to always have cards to win pots. Limit is a game of playing the odds properly. If you play strong starting hands and don't chase cards with bad odds then you should show a profit.