It could be a few things but the one that comes to mind is the splice behind the drivers side headlight, This splice joins the left and right side electrically for the path to ground and is famous for corroding.
As for the trans get it scanned by a trany shop as soon as possible the longer you drive it the more hard parts you could be damaging.
Dan.
Canadian "EH"