Foxhound is the better* Database Monitor for SQL Anywhere.
*better: More thorough, more relevant, more effective.
...more Alerts, more All Clears, more details, more control in your hands.
Last modified: December 9, 1996
mail to: email@example.com
How do I suppress the standard ODBC dialog box that appears when the user enters the wrong password? I want my program to handle it.
Here's what this annoying dialog box looks like:
Look up "ConnectOption" in the PowerBuilder Help and you'll see that a whole new hierarchy of ODBC parameters has been added with PowerBuilder 5. One of these new parameters, called "SQL_DRIVER_CONNECT", has a value "SQL_DRIVER_NOPROMPT" which tells the ODBC driver to return an error if anything goes wrong with the connect statement.
Here's an example of the ConnectOption string embedded within a DBParm value:
string ls_user_id string ls_password // Code to fill user id and password goes here. // e.g., ls_user_id = "DBA" // ls_password = "garbage" SQLCA.DBMS = "ODB" SQLCA.DBParm = "ConnectString='DSN=MyData;UID=" & + ls_user_id & + ";PWD=" & + ls_password & + "',ConnectOption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT'" connect using SQLCA; if SQLCA.SQLCode <> 0 then MessageBox ( "Error", "Connect failed" ) halt end if MessageBox ( "Error", "Connect OK" )