ASP.NET, SQL Server, WPF, C#, VB.NET

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...

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 ?

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 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...

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...