I just had the same thing with ours...only 55,700 on it and the check engine light came on...experienced the same problem that you had. At first I was thinking if it was because of the hot weather (it was near 105F that day).
The following morning, it was gone. Had oil change as one recommended and also had a fuel injection changed and hoping the problem would never come back.
Two weeks later, it came back and I had it diagnosed at an auto shop ant it came up as a solenoid.
Unfort. no one local can fix something like this but the dealership and since I had a warranty, they have to do a diag. and take everything apart for a thorough inspection. I usually don't get the warranty for cars but this time I did and I guess I'm glad I did (like others, ours is up to 77,000).
Warranty insurance was only willing to cover $1,000. The repair for the replacement of the solenoid and wire harness (and new transmission fluid) came to around $996 or something like that.
But there is the transmission filter which insurance does not cover and because for the Vibe, they really need to get into things... I was calling around and we were told by other autoshops that the quote for a trans. filter they gave us, which was $165 was reasonable. Uggh...of all times to not have any money but always have something for emergencies.
Needless to say, I was very disappointed that this solenoid thing happened. Noticed it has happened to to others and my main worry is that it may happen again. I know nothing about solenoids or how many their are inside a Vibe but with this malfunctioning one, right now it's getting repaired and I hope it doesn't happen again.
According to the repair, this repair has a warranty up to 1 year (12,000 miles). Duration without a car - 3 days (in my experience). No rental given because it's considered a "day's work" even though 1-day for diag. and the ordering the part and then getting it on Wednesday and working on it that day.