Originally posted by lewis:
the Cam Shaft Sensor was bad....He replaced it. When the code was reset the car ran fine until it was turned off and turned back on.



IIRC, the reason the code reset only after the engine was turned off and restarted, is becasue the cam sensor is only used by the PCM to figure out when #1 piston is on the compression stroke when cranking the engine. (Without the cam postion sensor, when #1 cylinder comes up on TDC, the PCM can't tell if #1 is on the compression stroke or the exhaust stroke, so it doesn't know which fuel injector to fire - #1's or its companion cylinder (half way down the firing order). With no cam postion sensor signal, some PCMs try firing the injectors at random to see if it can by chance fire the correct injector and get it to start.

So it sounds like your PCM is not getting a good cam position sensor signal and is therefor setting a code and lighting the MIL lamp. (Just becasuse the PCM is not receiving a cam postion sensor signal during cranking doesn't mean that the cam position sensor is bad, it just means that its not getting the signal. It may not be receiving the signal becasue of a wiring or connector issue (as someone already mentioned.)

Originally posted by lewis:
The noise is kind of a rattling sound. My husband says that it sounds like it is coming from the intake manifold.



Is this a V6? Might be the timing chain is striking the plastic valve cover (which is right under the upper intake manifold on the V6) and making a racket.