Thanks!
That was it!

Troy

>Troy,
>
>You've extra spaces around '=' in the 'DRIVER=' line which cause that dialog to popup. You can also add 'NETWORK=DBMSSOCN' option to the connection string so it'll use TCP/IP protocol regardless of the client configuration.

lcConnectionString="DRIVER=SQL Server;" ;
>		+ "SERVER=development;" ;
>		+ "NETWORK=DBMSSOCN;" ;
>		+ "UID=myUserID;" ;
>		+ "PWD=myPassword;"
>		+ "DATABASE=pubs"
>

See also Re: Verify connection Message #747337 on how to supress login and error ODBC dialogs.
>
>>How can I create a connection to an SQL Datasource without having a named DSN configured in ODBC?
>>
>>I try the following and a dialog appears with the ODBC configured names:
>
>>ch=SQLSTRINGCONNECT("driver = {SQL Server}; server=development; uid=sa; pwd=secretpassword; database=pubs")