At this stage of my exploration I'm using sql server express, no ssis package there. No biggie. I'll walk another path.
Many thanks.
>If you're using SQL Server 2008 64 bit, the only way to get data from VFP or to VFP from SQL Server is to use SSIS package.
>
>See this blog post explaining all the steps:
>
>
Working with 32 bit providers and 64 bit SQL Server>
>
>>The fact that I get :
>>
>>"Could not locate registry entry for OLE DB provider 'VFPOLEDB.1'."
>>
>>when I execute this sqlserver express r8:
>>
>>
>>select * from openrowset ('VFPOLEDB.1', 'c:\data\plucz\plucz.dbc'; ' '; ' ','select * from polished')
>>go
>>
>>
>>is a 64bit issue right? No point in exploring this any further, is what I'm really asking.
>>
>>From about in management studio:
>>
>>Microsoft SQL Server Management Studio 10.50.1600.1
>>Microsoft Data Access Components (MDAC) 6.1.7600.16385
>>Microsoft MSXML 3.0 4.0 5.0 6.0
>>Microsoft Internet Explorer 8.0.7600.16385
>>Microsoft .NET Framework 2.0.50727.4963
>>Operating System 6.1.7600
>>
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.