Problem with FoxPro LinkedServer

[pcawdron]

I'm having problems linking SQL Server to an old FoxPro database. My queries run fine in Access, but in SQL Server, using a linked server, I get OLE DB Provider error.

Error 7399 - Incorrect Syntax near 'SELECT XXX.* FROM XXX'

I used a .udl file to build a correct Provider string

Any ideas?

 

[tlbroadbent]

Check the following link for an article explaining "HOWTO: Do SQL Server 7.0 Distributed Queries With FoxPro .dbf Files." Verify that you have the correct syntax in your query.

http://support.microsoft.com/support/kb/articles/Q207/5/95.ASP

You may also want to read the following.

http://support.microsoft.com/support/kb/articles/Q241/2/67.ASP

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.