Linked Server VFP, error OLE DB

Hi,

SQLExpress on Windows XP SP2, authentification mode Windows

I trie to link a Visual FoxPro database with OLEDB provider (yet installed)
That query :
EXEC master.dbo.sp_addlinkedserver
@server = N'MyLinkedServer',
@srvproduct=N'Visual FoxPro 9',
@provider=N'VFPOLEDB',
@datasrc=N'"C:\MyPath\MyDirectory\"',
@provstr=N'VFPOLEDB.1'

works fine (no error)

but that one : select * from MyLinkedServer...MyTable return following error
message:
Cannot create an instance of OLE DB provider VFPOLEDB for linked server
"MyLinkedServer".

What's wrong ?

Cindy
Thu May 25 13:27:30 CDT 2006

Hi Michel,

Go to Server Objects > Linked Servers > Providers > VFPOLEDB > Properties >
Provider Options and try checking the Allow inprocess box.

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


"Michel LEVY" <stop.michelvfplevy@nospam.yahoo.fr> wrote in message
news:uX2rYbBgGHA.4880@TK2MSFTNGP03.phx.gbl...
> but that one : select * from MyLinkedServer...MyTable return following
> error message:
> Cannot create an instance of OLE DB provider VFPOLEDB for linked server
> "MyLinkedServer".

Michel
Thu May 25 14:54:27 CDT 2006

Hi Cindy,

You mean in SQL Server Management ?
I can't find any way to get properties on VFPOLEDB (or on any of the
providers I find here).
Perheaps this feature is disabled in SQL Express? or is it a local policy on
the domain (very secured) ?

I get that error each time I run that query, and each time it generates an
log error in system event viewer (in computer management console). Full text
of that error is:
**
Unable to start a DCOM server {here a clsid - not the clsid I can see in
Registry for vfpoledb}.
The error "The system cannot find the file specified." happend while
starting this command:
C:\windows\system32\dllhostexe/processid {here the same clsid}
**

the clsid is found in registry as "MSDAINITIALIZE" in hk_class_root\appid,
and msdac.msdainitialize (same hive)


"Cindy Winegarden" <cindy_winegarden@msn.com> a écrit dans le message de
news: uDszGlCgGHA.1204@TK2MSFTNGP02.phx.gbl...
> Hi Michel,
>
> Go to Server Objects > Linked Servers > Providers > VFPOLEDB > Properties
> > Provider Options and try checking the Allow inprocess box.
>
> --
> Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
> cindy_winegarden@msn.com www.cindywinegarden.com
>
>
> "Michel LEVY" <stop.michelvfplevy@nospam.yahoo.fr> wrote in message
> news:uX2rYbBgGHA.4880@TK2MSFTNGP03.phx.gbl...
>> but that one : select * from MyLinkedServer...MyTable return following
>> error message:
>> Cannot create an instance of OLE DB provider VFPOLEDB for linked server
>> "MyLinkedServer".
>
>

Cindy
Thu May 25 22:19:29 CDT 2006

Hi Mike,

You're right - SQL Express doesn't have the Properties option. You can
change the InProcess setting with the following code:

USE [master]
GO
EXEC master.dbo.sp_MSset_oledb_prop N'VFPOLEDB', N'AllowInProcess', 1
GO


--
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
cindy@cindywinegarden.com


"Michel LEVY" <stop.michelvfplevy@nospam.yahoo.fr> wrote in message
news:uzjoJUDgGHA.356@TK2MSFTNGP02.phx.gbl...
> Hi Cindy,
>
> You mean in SQL Server Management ?
> I can't find any way to get properties on VFPOLEDB (or on any of the
> providers I find here).

Michel
Fri May 26 04:29:13 CDT 2006

Cindy,

Thanks, that did it !

I definitely need a good training on SQL Server...

"Cindy Winegarden" <cindy_winegarden@msn.com> a écrit dans le message de
news: O2Jp5PHgGHA.4892@TK2MSFTNGP02.phx.gbl...
> Hi Mike,
>
> You're right - SQL Express doesn't have the Properties option. You can
> change the InProcess setting with the following code:
>
> USE [master]
> GO
> EXEC master.dbo.sp_MSset_oledb_prop N'VFPOLEDB', N'AllowInProcess', 1
> GO
>
>
> --
> Cindy Winegarden MCSD, Microsoft Most Valuable Professional
> cindy@cindywinegarden.com
>
>
> "Michel LEVY" <stop.michelvfplevy@nospam.yahoo.fr> wrote in message
> news:uzjoJUDgGHA.356@TK2MSFTNGP02.phx.gbl...
>> Hi Cindy,
>>
>> You mean in SQL Server Management ?
>> I can't find any way to get properties on VFPOLEDB (or on any of the
>> providers I find here).
>
>