So as late as the 19th century, people were just drinking regular water, believing there was nothing wrong with it. (This, plus the fountains and wells that have existed since antiquity as public places to both drink water and wash your hands... eww)
http://www.ph.ucla.edu/epi/snow/choleratheories.html