FoxPro Linked Server not working in 2005

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I can set up a linked server to a FoxPro DB in SQL 2000 but in 2005 it
fails. I know it says something about leaking memory on a listing on
the MS site, but I don't even get a link that works.

Here is what happens in a Win2003Server, SQLServer2005, latest VFPOLEDB
from MS site environment.

1) If I try to create a linked server from the management studio, it
requires a product name in 2005. This is not required when I try to
make the linked server in 2000.

2) If I use a SQL command to create the linked server, I can make it
without the product name but it does not work in 2005 but does in 2000.


sp_addlinkedserver 'Server1', '', 'VFPOLEDB', 'c:\company.dbc'

Looking for thoughts on how to troubleshoot this!!

Doug Hoogervorst

.

Relevant Pages

  • RE: 0x80004005 - you need permission to view its data
    ... When creating the Access linked server, make sure the data source using UNC ... the SQL server(Both SQL authentication and Windows Authentication work). ... 262177 How to enable Kerberos event logging ...
    (microsoft.public.sqlserver.security)
  • Linked Servers - Real Post
    ... I am running SQL 2k on Win 2k. ... a front end for our SQL database. ... added the linked server I want, and SQL queries it fine, ... leaving the "local server login to remote server login" ...
    (microsoft.public.sqlserver.programming)
  • Linked Server - Issue
    ... I have to access a Linked Server S2 (SQL 2000). ... In S1 I have setup a linked server using sp_addlinkedserver pointing to S2. ... Both MyAccount and SpecialAccount has access permissions to S2. ... Reason Not associated with a Trusted SQL ...
    (microsoft.public.sqlserver.programming)
  • OLE DB provider "SQLNCLI10" for linked server "XXXXXX" returned message "The stored procedure requir
    ... I am getting the exact results with an upgrade of SQL 2005 to 2008 querying a ... If I choose the linked server type as SQL Server to create the ...
    (microsoft.public.sqlserver.server)
  • Re: Transfering only updated data (from as400 to SQL2000)
    ... Rifat, ... Create a linked server of the AS400. ... > will identify rows that require moving at ETL time. ... >> as400 to SQL. ...
    (microsoft.public.sqlserver.dts)