Re: Linked Server to FoxPro

From: Cindy Winegarden (cindy.winegarden_at_mvps.org)
Date: 09/17/03 

Date: Tue, 16 Sep 2003 23:28:24 -0400

Hi Sohail,

I can't say much about your error, but you might have better luck with the
FoxPro and Visual FoxPro OLE DB provider, downloadable from
http://microsoft.com/downloads/details.aspx?FamilyId=0F43EB58-7A94-4AE1-A59E-965869CB3BC9&displaylang=en. 

-- 
Cindy Winegarden  MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@mvps.org, www.cindywinegarden.com
"Sohail Younus" <syounus@consultparagon.com> wrote in message
news:03cd01c37c8b$ca5ee1a0$a301280a@phx.gbl...
> I have a Linked Server connecting to FoxPro database using
> Visual FoxPro ODBC.  It was working fine.  All of a sudden
> it stopped working and giving the error below when trying
> to use the linked server.  Any feedback will be greatly
> appreciated.
>
> "OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an
> error. Authentication failed.
> [OLE/DB provider returned message: Cannot start your
> application. The workgroup information file is missing or
> opened exclusively by another user.]
> OLE DB error trace [OLE/DB
> Provider 'Microsoft.Jet.OLEDB.4.0'
> IDBInitialize::Initialize returned 0x80040e4d:
> Authentication failed.]."
>

Relevant Pages

  • Re: HowTo Configure VFPOLEDB on W2K3
    ... If you have installed the OLE DB Provider as Cindy suggested, ... Files\Microsoft Visual FoxPro OLE DB Provider\ folder. ... This folder contains ...
    (microsoft.public.fox.programmer.exchange)
  • VFPOLEDB documented bug #607106??
    ... it a VFP problem? ... am having is that an attempt by me to use the VS 2005 ATL OLE DB Consumer ... provider for Visual FoxPro crashes the wizard and VS 2005 IDE along with it. ...
    (microsoft.public.fox.vfp.dbc)
  • Re: linked dBase tables
    ... Could not fetch a row using a bookmark from OLE DB provider 'VFPOLEDB'. ... >> However we have problem running the above SQL statements querying the ... > I haven't ever worked with Java, but the FoxPro and Visual FoxPro ODBC ...
    (microsoft.public.sqlserver.programming)
  • Re: FOX 2.5 and VB.Net 2005
    ... this is a VB6 forum. ... You can download the latest FoxPro and Visual FoxPro OLE DB data provider ... native OLEDB data types exposed by the OLEDB provider to Fox data types. ...
    (microsoft.public.vb.database.ado)
  • Re: Need to Convert VFP8 query to ADO
    ... You'll be far better off using the FoxPro and Visual FoxPro OLE DB data ... For the connection string you can use this: ... that the VFP OLE DB data provider understands when you pass ... Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP ...
    (microsoft.public.vb.database.ado)