I am having difficulty verifying my Availability Group Listener configuration. I would like to create an ODBC connection which points to the listener. When I configure the system DSN and try to test the connection at the end, I get timeout errors. However, when I change the server to point to the instance name instead of the listener name, the connection works. How can I test the listener using ODBC? What other method can I use to test the listener?
Note: I do not have access to an application to test client connectivity.