Northampton kept alive their hopes of playing in the European Champions Cup next season with a hard-fought 21-15 victory over Connacht in the second play-off at Franklin's Gardens.