I have successfully created my linked vfp server on the Sql Server instance. When I run the query like you have below I get an OLE/DB provider error" Invalid path name.

I have checked the properties of my linked server in the Sql Manager and they all have the correct attributes such as Provider, Data Source, Location, Provider String, and Product name.

I have tried adding the path and the linked server as a prefix to the table name in the OpenQuery function but that does not work either.

Any ideas?

Code:

lcQuery = "select * into " + lcTableName + " from OpenQuery( " + tcLinkedServer + ", 'select * from " + lcTableName + "' ) "

SQLEXEC( tnConn, lcQuery )