>Hi gang,
>
>We're running into a problem connecting with SQL Server. In a nutshell, here it is:
>
>The user is presented with a dialog with their user name display to enter their password. If the user incorrectly enters the password, the ODBC driver pops up dialog for them to make the correction. If they enter the correct password there, we don't have access to what the correct password is. Thus, if we try to connect to another data source, the same process has to be repeated. Is there anyway to stop the driver from popping up the dialog so that we can re-prompt them for the correct pasword?

George,

Use SQLSETPROP to disable ODBC login screen

IF SQLGETPROP(0,'DispLogin') <> 3
llOk = (SQLSETPROP(0,'DispLogin',3)=1) && No login screen, error on fail
ENDIF