Tom,
If you check the return value of sqlstringconnect() or sqlconnect() it should tell you if the connection is valid. You use aerror() to see why it couldn't connect.
>The connection designer has a button to verify a connection. I am trying to do this programmatically to check the status of a remote connection within my code before trying to access it. Anybody have an idea on how the connection designer does it?