Re: Linked Servers

EvanHennis (EvanHennis@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
> I will have to wait until tomorrow when he comes back in.
>
> I did notices that when I added him as a log in for my computer he was
> able to run the linked server without any issues. Would there be a
> Windows issue with the VFPOLEDB.DLL?

No, that was a piece of information! Since you did not say anything,
I assumed that the other server as an SQL Server as well. So it's a
FoxPro database. Well, that would have been clear from the complete
error message anyway, I believe.

Unfortunately, I have no experience of FoxPro. But I doubt that the
DLL would matter. Permissions on the database file sounds more likely
to me.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
.

Relevant Pages

  • Cached Data to Linked Server
    ... I have SQL Server 7.0 set up to access a flat file FoxPro database sitting ... on an NFS mount as a linked server. ... I've tried setting "remote login timeout", ...
    (microsoft.public.sqlserver.connect)
  • Linked servers, OLEDB cache and timeouts
    ... I have SQL Server 7.0 set up to access a flat file FoxPro database sitting ... I've tried setting "remote login timeout", ...
    (microsoft.public.data.oledb)
  • Linked servers, OLEDB cache and timeouts
    ... I have SQL Server 7.0 set up to access a flat file FoxPro database sitting ... I've tried setting "remote login timeout", ...
    (microsoft.public.sqlserver.programming)
  • Re: RDA with SQL Express
    ... I have never used SQL Server Everywhere but you can do RDA with SQL Server ... Access is a dying database technology which I don't *think* is supported on ... I have data on a server that is in a foxpro database. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Error: 16954, Severity: 10, State: 1 and Timeout problem
    ... On this DB are runing lot of threads from different applications. ... Probably, other aplication are locking resources, so the first one need ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)