I am using the below in my app to query a SQL Server table. Sometimes while running the example below, a dialog will appear with my SQL Server UID and PW in the dialog waiting to someone to press 'Ok'. The app is hung until someone response to the dialog.
What causes the dialog to appear? Is there a way to trap for it? Whats the recommended way of handling this?
o = CREATEOBJECT([wwsql])
ll_isconnected = o.ConnectByDsn('Mydsn', 'myuid', 'mypw')
ln_sqlresult = o.Execute(tc_sql)
Thanks,
Jerry
