You can supress error and login dialogs

* Suppress ODBC error dialog
IF SQLGETPROP(0,'DispWarnings')
  = (SQLSETPROP(0,'DispWarnings',.F.)  && No errors
>ENDIF
* Suppres login dialog if needed
IF SQLGETPROP(0,'DispLogin') <> 3
  = (SQLSETPROP(0,'DispLogin',3)  && No login -- error on fail
ENDIF
...
IF SQLSTRINGCONNECT(lcConnStr)< 1
  * Error. Use AERROR() function to return detailed info about ODBC error.
  * Process this error
ENDIF

>How do I prevent the select data source window from poping up when I execute the following code? Why doesn't this code just create the connection string?
>
>
>lcDSNLess="DRIVER = {SQL Server};" ;
>+ "SERVER=[ServerName];" ;
>+ "UID=[useid];" ;
>+ "PWD=[password];" ;
>+ "DATABASE=[database]"
>
>lnconnhandle = Sqlstringconn(lcDSNless)