Fix missing connector message + other improvements

- test: isolate `testConnection` tests
- testConnection: fix a typo in error message
- datasource-invoke: handle sync errors
- report `ping` errors as HTTP 200

/to @ritch please review