CN2 is (as labelled) an ICSP socket (In Circuit Serial Programming), which you can use to program the chip in it's final board - assuming you design the board accordingly!.
This is not a good design for a programmer. Circuits that derive there power from the serial port tend not to work with modern PCs. Have a read of this page for example circuits and explanations of how they work etc. There is also a FAQ.