Visual FoxPro SQL Queries - Linked Server with vfpoledb

Author

Linked Server with vfpoledb

john Doe

2006-01-04, 8:25 pm

Hi

I am having difiuclty in setting up a linked server on SQL 2000 to work with
a foxpro database.

I am using foxpro 8 and the relevant oledb driver downloaded from MS
website. However when I try to use the linked server
I recieve the folowing error:

Server: Msg 7403, Level 16, State 1, Line 1
Could not locate registry entry for OLE DB provider 'vfpoledb'.OLE DB error
trace
[Non-interface error: Provider not registered.].

I have tried unregistering and registering the vfpoledb.dll to no effect.
The strange thing is that I have used the extended stored
xp_enum_oledb_provid
ers and this defintety shows that VFPOLEDB is
registered.
Also I can select the microsoft oledb driver for visual foxpro from the
properties page to set up the linked server in the first place.

Any insight would be very much appreciated.

Lee Mitchell

2006-01-05, 9:24 am

Hi Karl:

You said you unregistered and registered the VFPOLEDB.dll file. That is
good. However, will you try thee steps:

1. Copy the VFPOLEDB.DLL to another folder
2. Uninstalled the provider from Control Panel - Add
Remove Programs.
3. Copy the VFPOLEDB.DLL back to the C:\Program Files\Common
Files\System\Ole DB folder
4. Run REGSVR32 on VFPOLEDB.DLL and try the code again.

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/

*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/i...cid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/gp/lifeselectindex
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003

>Hi

>I am having difiuclty in setting up a linked server on SQL 2000 to work
with
>a foxpro database.

>I am using foxpro 8 and the relevant oledb driver downloaded from MS
>website. However when I try to use the linked server
>I recieve the folowing error:

>Server: Msg 7403, Level 16, State 1, Line 1
>Could not locate registry entry for OLE DB provider 'vfpoledb'.OLE DB error
>trace
>[Non-interface error: Provider not registered.].

>I have tried unregistering and registering the vfpoledb.dll to no effect.
>The strange thing is that I have used the extended stored
>registered.
>Also I can select the microsoft oledb driver for visual foxpro from the
>properties page to set up the linked server in the first place.

>Any insight would be very much appreciated.

Cindy Winegarden

2006-01-05, 11:24 am

Hi Karl,

Try VFPOLEDB.1 as the provider string. That's what I've been using.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn
.com www.cindywinegarden.com

"john Doe" <karl.willis@btopenworld.com> wrote in message
news:%23r1RYYYEGHA.2724@TK2MSFTNGP12.phx.gbl...
> Hi
>
> I am having difiuclty in setting up a linked server on SQL 2000 to work
> with
> a foxpro database.
>
> I am using foxpro 8 and the relevant oledb driver downloaded from MS
> website. However when I try to use the linked server
> I recieve the folowing error:
>
> Server: Msg 7403, Level 16, State 1, Line 1
> Could not locate registry entry for OLE DB provider 'vfpoledb'.OLE DB
> error
> trace
> [Non-interface error: Provider not registered.].
>
> I have tried unregistering and registering the vfpoledb.dll to no effect.
> The strange thing is that I have used the extended stored
> xp_enum_oledb_provid
ers and this defintety shows that VFPOLEDB is
> registered.
> Also I can select the microsoft oledb driver for visual foxpro from the
> properties page to set up the linked server in the first place.
>
> Any insight would be very much appreciated.
>
>

Sponsored Links