Two days of heavy rain have bought chaos to western Europe, killing over 40 people and bringing down houses.