Q:

Solder vs screw connection on a cable connector

I bougth some 4mm male banana jacks today with the purpose of making myself some more test leads. They have screw connection, similar to the ones in this picture (from the farnell product page):
 
I wondered if I should stick to the screw connection, or if I should fill the hole with solder and insert the cable into that. The guy in the store said they solder all theirs - just get rid of the screw and fill it up with solder.
My first idea would be that "solder is clearly better, it's a pure metal connection!" but I know that this is likely false - crimp connectors are much more reliable than solder joints. Is this also the case here? I'm worried that since it will be moving a lot, the edge of the screw pin might cause a cutting to occur.
I'm going to be working with quite thin cables (0.5mmsq) because the other end is going into a micrograbber style connector, that can only accept this thickness. I mention it because I don't know if this changes things.

A:

There are four issues with soldering the connectors.

You have to get the connector and wire VERY HOT to get a good solder joint. That means the solder will wick up the wire a long way and the insulation will likely melt back on you.
Where the flexible wire meets the stiff solder, an interface is generated that becomes a stress riser where the individual wire segments will break easily.
The heat from soldering itself can damage the properties of the connector and make it rather hard to repair or re-use.
Connectors, and crimps, are normally plated with materials, like chrome, which are not compatible with standard solder and flux.

As such I recommend the following options.
1. Tight Fit Wires Tinned End.

Trim back sufficient insulation to allow you to insert the wire so the insulation butts to the shell. Tin the end of the trimmed wire to just past the screw location and screw it in place normally. Try not to allow the solder to wick too far up past the screw down point.
2. Medium Fit Wire : Bend back and shrink fit.

Medium sized wires should be trimmed sufficiently to allow you to bend the wire back on itself and the bent part tinned and screwed. This time add two inches of heat shrink tubing to the wire so it fits snuggly within the housing hole.
2. Fine Wire : Slug and Double Shrink.

With really fine wires you can not expect to use the lead screw to tighten down on the wires. As such you need to use some thicker grade wire to make a "slug" that will fit in the connector to take the screw force. The end of the wire should be looped and soldered to that slug. 
This time you should use two layers of heat-shrink tubing for bending strain relief. If it will fit, allow the original insulation to be inside the connector. 
With fine wires additional strain relief will be required if heavy usage is expected on the connector. 
Adding the Cap

IMPORTANT Remember to slide the connector cap onto the wire before you do any of the above. When finally sliding it into place and screwing it down be careful to ensure that the cap does not cause the wire to twist relative to the connector or it may break off inside. 

Added Adhesives And Strain Relief
You can buy banana connectors that actually have strain relief features built into them. However the following measures can be taken to improve matters if those are unavailable or cost prohibitive. 
Once joined to the wire the cap should be a fairly tight fit around the insulation or heat shrinking. If not you can use a flexible adhesive, like silicone, to augment the join under the cap. 
Alternatively, you can dispense with the cap entirely and make your own from heat-shrink tubing that covers both the wire and the threaded part of the body.

For production cables this last step is normally molded onto the cable assembly.
In Conclusion
As with ALL connectors, mechanical stability is the key factor. The initial electrical connection is actually easy to achieve, but once made, it is important to ensure that any mechanical movement on that connection is kept to a minimum if not eliminated entirely. 

