Linked Server VFPOLEDB gives Access Denied error

When I login to the windows server as administrator, the query runs.  When I
login as anyone else (incl a user with as many admin rights as I can give
him), I get the following error:

Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "VFPOLEDB" for linked server "A" reported an error.
Access denied.
Msg 7301, Level 16, State 2, Line 1
Cannot obtain the required interface (" IID_IDBCreateCommand
") from OLE DB
provider "VFPOLEDB" for linked server "A".


Any help would be appreciated.

"Ashley Brewerton" < AshleyBrewerton@disc
ussions.microsoft.com> wrote in
message news:800A97D6-2A65-4A2C-A746- 56A4D4931C2A@microso
ft.com...

Hi Ashley,

Be sure you have the latest FoxPro and Visual FoxPro OLE DB data provider,
downloadable from msdn.microsoft.com/vfoxpro/downloads/updates .

Here's what works for me to set up the Linked Server in SQL 2005 using the
Linked Server dialog:

Providers list: VFPOLEDB shows as an entry
Linked Servers > New Linked Server ...
Linked Server: MyLinkedServer
Provider: Choose "Microsoft OLE DB Provider for Visual FoxPro
Product name: Visual FoxPro (I think this is optional)
Data source: "C:\Program Files\Microsoft Visual
 FoxPro9\Samples\Nort
hwind\Northwind.dbc"  (Include quotes since there's
spaces in the string.)
Provider string: VFPOLEDB.1
Location: (blank)
Catalog: (blank)
Security page and Server Options page take defaults.

> When I login to the windows server as administrator, the query runs.  When
> I
> login as anyone else (incl a user with as many admin rights as I can give
> him), I get the following error:

What permissions does the SQL Server local system account have?

I'm ok on my laptop with the SQL Server started with "local
system account" and my Windows login being MachineName\Cindy. When I tried
against my SQL Express instance which was started using the "NT
 AUTHORITY\NetworkSer
vice" I had the same errors you report.

> Cannot obtain the required interface (" IID_IDBCreateCommand
") from OLE DB
> provider "VFPOLEDB" for linked server "A".

How are you executing your query? With the four-part naming or using
OpenQuery()?


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

Hi Cindy

Yes, I saw your previous post and have already tried the setup you
indicated.  I run the query using the standard select syntax::

select * from AURORA...CMaster

"Cindy Winegarden" wrote:

> "Ashley Brewerton" < AshleyBrewerton@disc
ussions.microsoft.com> wrote in
> message news:800A97D6-2A65-4A2C-A746- 56A4D4931C2A@microso
ft.com...
>
> Hi Ashley,
>
> Be sure you have the latest FoxPro and Visual FoxPro OLE DB data provider,
> downloadable from msdn.microsoft.com/vfoxpro/downloads/updates .
>
> Here's what works for me to set up the Linked Server in SQL 2005 using the
> Linked Server dialog:
>
> Providers list: VFPOLEDB shows as an entry
> Linked Servers > New Linked Server ...
> Linked Server: MyLinkedServer
> Provider: Choose "Microsoft OLE DB Provider for Visual FoxPro
> Product name: Visual FoxPro (I think this is optional)
> Data source: "C:\Program Files\Microsoft Visual
>  FoxPro9\Samples\Nort
hwind\Northwind.dbc"  (Include quotes since there's
> spaces in the string.)
> Provider string: VFPOLEDB.1
> Location: (blank)
> Catalog: (blank)
> Security page and Server Options page take defaults.
> 
>
> What permissions does the SQL Server local system account have?
>
> I'm ok on my laptop with the SQL Server started with "local
> system account" and my Windows login being MachineName\Cindy. When I tried
> against my SQL Express instance which was started using the "NT
>  AUTHORITY\NetworkSer
vice" I had the same errors you report.
> 
>
> How are you executing your query? With the four-part naming or using
> OpenQuery()?
>
>
> --
> Cindy Winegarden  MCSD, Microsoft Visual FoxPro MVP
>  cindy_winegarden@msn
.com  www.cindywinegarden.com
>
>
>