There should be a connector that plugs into the transmission itself. However, the CEL may not show up until it is being driven and only under certain driving conditions. The ECM monitors torque converter slippage and it'll throw a code when it notices the converter not unlocking.

The fix is to find an ECM out of a manual transmission truck with the same engine and same year. Ebay would be where I would start looking.