>>>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)?
Yep.
>Doesn't SQLSETPROP only work with SPT?
Nope. A remote view is basically a wrapper around SPT, so once you get the connection handle of the view, you can treat it just like an SPT connection.
>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.
Yes, but that's something like ON ERROR *. You don't see the errors, true, but you also don't see what's going wrong. Targetted fixes are much better, IMNSHO.