Tip 55: The ConnectOption DBParm Parameter

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" )