Open a connection to a remote
The transport is selected based on the URL
the remote to connect to
GIT_SUCCESS or an error code