Hi!

>thank ypu very much, but i don't know how to use 'ODBC connection string'

Try following in the VFP command window:

nn = SQLStringConnect("Driver=SQL Server;SEREVR=MYSERVERMACHINENAME;Database=MyDatabase;UID=sa;PWD=password;")
SQLEXEC(nn,"SELECT * from MyTable","MyCorsor")
select MyCursor
browse normal

Instead of MYSERVERMACHINENAME put the name of the SQL Server. Do the same with other values (database name on SQL Server; UID - user name, PWD - password, oristead of the use TRUSTED_CONNECTION=YES if SQL Serevr allows tructed connection).

Take a look to the help file for SQLStringConnect and SQLExec functions.

When you design connection in the connection designer, choose second option (connection sting), then put the content of above SQLStringConnect function call (Driver=SQL Server;SEREVR=MYSERVERMACHINENAME;Database=MyDatabase;UID=sa;PWD=password;), then test it.

HTH.