See Re: Linked server with the database on VFP Thread #700708 Message #727555.

>Hi,
>Yes.. you are right!!
>
>Again, I am able to
>

>?SQLEXEC(lnHandle, "sp_linkedservers", "curls")
>?SQLEXEC(lnHandle, "sp_tables_ex 'vfptestlink1'", "curlstable")
>
>sucessfully
>
>but
>
>?SQLEXEC(lnHandle, "SELECT * FROM VFPTESTLINK1...member", "csrmember")
>
>failed.
>
>

>Is it the way to access table ?
>Somemore, I try to create connection using VFP, but the linkedserver is not listed in database combo list.
>
>I am new to SQL server actually.