Its 2 wheel drive, but the transmission won't shift unless you manuallyl put the gear shifter in low then work your way up to get the gears to change. The gears work fine it just won't change on its on. If you leave it in drive to start off it feels like its pulling a heavy load, which I do think its trying to start off in high gear. what could this be?

Trans shifts into gear harshly, car feels sluggish off the line, No 1st, 4th or TCC lockup available, Manual 2nd, 3rd and Reverse are only available gears, CEL is on: Transmission is either in limp-home mode or has lost electrical power. If there are lots of error codes in the PCM, check the under-hood fuse that powers the transmission, and if it pops again, look for a short in that circuit like an O2 sensor harness touching exhaust. Otherwise, check PCM codes for a particular fault in the transmission causing the PCM to put it in limp-home mode.

No 1st or 4th available; trans shifts 2nd to 3rd by itself in D or OD and locks the converter : ShiftA solenoid failed. Easy fix in the pan. Or a wiring problem from PCM to trans.. or PCM.

Car goes into gear but feels very sluggish like the brakes are dragging, but it will roll easily (starts out in 4th gear), you manually shift to 2 to get it moving, once it's moving you put it back in OD and the car shifts 3rd to 4th on its own and locks the converter at the appropriate time: ShiftB solenoid failed: Easy fix in the pan. Or a wiring problem from PCM to trans.. or PCM.

Good luck and keep me posted, there are other things but these things mentioned seam like what you described.