Being disconnected is what was detected by the Engine Computer. It set the diagnostic fault code and turned on the Check Engine light. First, be aware fault codes never say to replace a part or that one is bad. They only indicate the circuit or system that needs further diagnosis, or the unacceptable operating condition. When a sensor or other part is referenced in a fault code, that part is actually the cause of that code about half of the time. This is a perfect example of how we have to check for damaged wires and problems with connector terminals before we spend you money on that part.
If the terminals in the temperature sensor are okay, and the latch on the connector body is not broken, there is likely no need to replace it. Temperature sensors have an extremely low failure rate because there's just one component inside them.
You can snip a connector off the harness from a similar car in the salvage yard. Also, all auto parts stores have multiple large books that show just about every connector for every car model. Since there's too many to have them all in stock, they will probably have to order the right one, but it usually only takes one or two days to get it in.
When you splice the wires, be sure to solder the joints, then seal them with heat-shrink tubing with hot melt glue inside. That will seal out moisture. Don't worry if the colors are different on the short pieces of wire that come with the replacement connector. For this application, the two wires can be switched without affecting circuit operation.
SPONSORED LINKS
Monday, November 4th, 2019 AT 4:12 PM