SQL Server Performance Forum – Threads Archive

Linking FoxPro Tables to SQL Server 2000

Hi,
I’m using at work a FoxPro Linked Server to my SQL Server 2000. I can see Fox’s .DBFs as tables and use them as well. When I try to do the same at a client’s SQL Server 2000 (both under W2K) I can’t see the tables, and sometimes I get error 3799 with no description. Any idea of how can I get this to run? Thanx JP

Any differences in the configuration between your dev SQL Server and the client’s SQL Server?
Nathan H.O.
Moderator
SQL-Server-Performance.com

I looked carefully at each server’s configuration and couldn’t find any difference.
Maybe it has something to do with the ODBC drivers version or something, really don’t know. Thanx for answering, JP

Looks like some issue with the drivers, try to re-register the linked server for foxpro and try on the client. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

Did that many times. I also re registered the ODBC source and still couldn’t see the tables. Then I asked for the Administrator pwd for Win2k. So I logged as Administrator, re registered the ODBC source and Linked Servers and discovered a new error: Error 7301: Could not obtain required interface from OLEDB provider ‘MSSearch.CollationDSO.1′ This is a ‘more attractive’ error as now I’m sure it has something to do with collation. Will continue trying to solve this. I would really appreciate if someone could help me a little bit with this. Thanx!! [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] JP

Make sure the query contained a pass-thru query (OpenQuery, or OpenRowset with query a inside it).
And SELECT/INSERT/UPDATE/DELETE statement against a 4-part name for which SQL Server generates a query against the provider for optimization.
_________
Satya SKJ
Moderator
SQL-Server-Performance.Com

]]>