Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL linkedserver
Message
From
30/11/2002 00:21:21
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00728292
Message ID:
00728316
Views:
22
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.
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform