In RAD 6 (the successor to WSAD), you can test the datasource through the admin console. I don't remember a way to do so in WSAD. This article confirms you need to write code to test the datasource in WSAD.
WSAD 5 only supports up to J2EE 1.3. Unless you are developing an old application, consider upgrading.