Metin,

Try:

lcStringConnect="DRIVER={SQL Server};SERVER=METIN-81PAL4R7V;DATABASE=northwind;UID=sa;PWD=sa_pw"
lnSql = SQLSTRINGCONNECT(lcStringConnect)

HTH
>i want to use sqlstringconnect without use dns. i tried sample which vfp gives in it's help and i cannot use it:
>
>it writes:
>"driver = SQL Server;server=your_server;uid=sa;pwd=sa_pw"
>
>and i tried:
>"driver = SQL Server;server='METIN-81PAL4R7V';uid=sa;pwd="
>
>METIN-81PAL4R7V is my sqlserver name.
>
>sql server give an error:
>
>dns name not found and default driver not specified (i convert this error message from turkish and syntax may be incorrect).