Linked Server to VFP database - client to SQL Server to FoxPro server

Last Post 24 Jun 2004 11:15 AM by KMITCHELL. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
KMITCHELL
New Member
New Member

--
24 Jun 2004 11:15 AM
The server which houses the foxpro database container (.dbc) was just upgraded to Win2003 from Win2000.

Prior to the upgrade, I was able to select from the foxpro database without issue, via a linked server whose basis is a ODBC connection defined in System DSN (on my PC and on the SQL server).

Post upgrade, I get a 'Cannot open file' message returned from attempt to select the data with a query in Query Analyzer running on my client PC.

SQLAgent on SQL server is running under local admin account. No change there.

My domain log in (which is how I am logged into my PC) is in the domain group with access to the foxpro data file.

Why with the Win2003 upgrade, would I no longer be able to select from the foxpro database container/database?

Any suggestions?

Thanks in advance,
KWM

You are not authorized to post a reply.

Acceptable Use Policy