The simplest cable only requires 3 wires. It carries the 2 data lines and the common/signal ground. You'll see that the Transmit (TxD) pin on one port is connected to the Receive (RxD) pin on the other. This cable is fine for situations where no flow control is required or where you intend to use only XOnXOff flow control. With this simplest of cables the Com port properties RTSEnable, DTREnable, CTSHolding etc will, of course, have no effect.
If you do wish to use RTS/CTS flow control or when you need the ability to change or detect changes in the RTS/CTS control lines then you will also need to connect the RTS and CTS pins as shown below.
If you wish to change the state of DTR or detect changes in the DSR control line then you will also need to make the connections shown below.
When DTR/DSR is connected like this then when one RS232 device sets its DTR line ON (DTREnable = True) then the other device would instantly detect that as a change in the state of its DSRHolding property. Many RS232 devices use this method to detect when the other device is connected and switched on ready to communicate.