>>Also, issue MODIFY CONN from the command window and you'll see some of the timeout values that you can configure from within VFP. The help topic for the "Connection Designer" also provide information that you might find useful.
>
>If I'm using:
>
>

>lnHandle=SQLStringConnect('Driver=SQL server;Server=MyPC; Database=Northwind;')
>

>
>Is there a way to have MODIFY CONNECTION to apply on it. When I do it, I have "No database is open or set as the current database". In order to use MODIFY CONNECTION, do I really need to CREATE CONNECTION first. If yes, should I do that before SQLStringConnection() or after?

If you are using DSN-less connections, you can set these values with SQLSETPROP() function.