SQL Server Performance

Linking FoxPro Tables to SQL Server 2000

Discussion in 'SQL Server DTS-Related Questions' started by JuanP, Aug 6, 2003.

  1. JuanP New Member

    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
  2. vbkenya New Member

    Any differences in the configuration between your dev SQL Server and the client's SQL Server?


    Nathan H.O.
    Moderator
    SQL-Server-Performance.com
  3. JuanP New Member

    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
  4. satya Moderator

    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
  5. JuanP New Member

    Did that many times. I also re registered the ODBC source and still couldn't see the tables.<br /><br />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:<br /><br />Error 7301: Could not obtain required interface from OLEDB provider 'MSSearch.CollationDSO.1'<br /><br />This is a 'more attractive' error as now I'm sure it has something to do with collation.<br />Will continue trying to solve this.<br /><br />I would really appreciate if someone could help me a little bit with this.<br /><br />Thanx!! [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br /><br /><br /><br />JP
  6. satya Moderator

    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

Share This Page