I am not sure if this is what you want, but I think SQLSTRINGCONNECT() is what you are looking for:


SQLSTRINGCONNECT('dsn=MyFoxSQLNT;uid=sa;pwd=FOXPRO')


This example is from the VFP6(MSDN) help.

HTH
Bill