I agree with Tom C. The store bought 4-40 rods actually have rolled threads on them and the rods are actually undersized so you won't be able to thread the other end with a 4-40 die. So short of using the mentioned solder on threaded adapters the only other thing would be full threaded rod.

Suburban95