|
Home > Archive > FoxPro Help and Support > January 2006 > Linked Server using vfpoledb
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Linked Server using 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.
| |
| 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:%23EgSIZYEGHA.2380@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.
>
>
|
|
|
|
|