In Shepherd
wrote:
Can anyone recommend a good rose for this project and the distance to
place the pots along the fence?

Your problem here is really the pots. Climbing roses that would cover a
fence would also outgrow a pot quickly.

One participant here (forget who he/she is) has a great picture of how
Madame Alfred Carriere can cover a fence or wall. It grows into a
thicket from the base, though.

Others you might consider are Albertine or maybe Altissimo. Again, both
of these are strong growers and they would not put up with pots for long.