^ just because the coil sparks doesnt mean it's working properly. Most bad coil packs will spark and work perfectly fine at idle but will break up under load. Thats why so many people have problems diagnosing blown coil packs.
If the speed sensor is not connected then your speedometer will read 0 mph when your driving.
are you throwing misfire codes? any cel?