if the odo works, the cable is fine and the trans is turning it, no need to disconnect that end - wouldn't leak anyway unless you drive with it off, and then it would be minimal - the speedo is the problem, and that could be a number of things, time to pull it apart

Bill