By Richard Palmer
With virtually the last kick of the match, Frain, signed just before deadline day from Birmingham, fired a free-kick past Roger Freestone's right hand from just outside the area and sent 30,000 Northampton fans into raptures.
"I was pretty sure it was going in as soon as I hit it" said the 28-year-old defender. "It's a dream come true, scoring here. I'm absolutely delighted. If you'd told me six months ago when I was at Birmingham that this was going to happen I wouldn't have believed it."
He scored with his second attempt at taking the kick, given when Keith Walker rashly brought down Christian Lee seconds after Swansea's Jonathan Coates was booked for running out early to block his first effort.
So Northampton celebrated their finest hour since the halcyon days of the mid-Sixties when they played in the old First Division. For much of the match, however it had been Swansea, driven on by Molby their player-manager, who had set the pace. Molby is a yard or two slower than in the days when he twice shared in Liverpool FA Cup triumphs at Wembley, but he has not lost the poise and sweet right foot that once graced Anfield and many of the world's finest stadiums.
It was Molby who made Swansea's best chance of the game when he headed through the middle to set up Carl Heggs for a fierce fifth-minute volley on the turn, which Andy Woodman just managed to tip over the bar.
But for all their control in midfield and the impressive running of Heggs up front, they could not find the net.
Only once, until the final fateful seconds, did the Welsh side's grip on the game look to be in real doubt.
After 20 minutes, they had a real scare when Molby was dispossessed just inside his own half by Neil Grayson. He went on to round Walker before laying on a perfect pass to Sean Parrish. As the Swansea defenders ran back in complete disarray, Parrish's shot was scrambled off the line by Edwards.
Then, just when it looked as if neither side would break the deadlock in normal time, up popped Frain to seal a famous victory.
Click here to go back to Wembley page