I have remote server which executs VFP SP into a table on a remote machine. Then from a client machine I get records from that table using SQLEXEC. After that the remote table becomes not accessable for remote server. If remote server tries to run SP again I have a message 'Access denied'. If I dont use SQLEXEC but simply SELECT * FROM 'remotetable' and then USE IN 'remotetable' everything is working fine. So I assume that SQLEXEC holds the remote table. My question is how to 'release' a remote table?
Thanks Mark
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only