I need to test to see if a database is running through a PowerBuilder application. Every time that I test the connection, and the database is down, the ODBC dialog box appears and the application just sits and waits for someone to respond to the window. Is there a way to suppress the window and just have SQLCA return the error code?
This is my DBParm setting SQLCA.DBParm = "ConnectString='DSN=DATASOURCE_TEST;UID=dba;PWD=sql;ConnectOption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT'"
PowerBuilder 2017 and SQL Anywhere 16.