>>>>I know there's an option to keep connection dialogs from
>>>>popping up on errors: if I can find this, would it solve
>>>>your problem, or are there more classes of problem to deal
>>>>with?
>>>I think dialogs are the main problem.
>>>Vin Miller says sys(2335,0) is the key to this.
>>>Is that what you were thinking of?
>>
>>Nope, that's not the one. There's a setting that's specific either to ODBC or SQL that keeps connection dialogs from popping up: the connect command just returns an error (-1) at that point.
>
>You mean SQLSETPROP(0, "DispLogin", 3)?

Doesn't SQLSETPROP only work with SPT? I also seem to recall an ODBC-specific setting regarding login prompts, such as Garrett is mentioning (maybe it was a "NO_PROMPT" in the ConnectOption or something like that... can't recall right now). But I bet that a sys(2335) in VFP would address it anyway.