Re: connect foxpro to sql server and copy table

Hi Bee,

Try this: Create a new text file and then rename it as Test.udl. Double
click on it to bring up the OLE DB data source dialog. On the Provider tab
is "Microsoft OLE DB Provider for Visual FoxPro" listed? If you choose that
and then on the Connection tab navigate to your database and click the Test
Connection button are you successful?


--
Cindy Winegarden
cindy@xxxxxxxxxxxxxxxxxxx


VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx




"Bee" <Bee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BB30C469-837E-4F42-9853-FCC9DD1795FA@xxxxxxxxxxxxxxxx
....
Could not locate registry entry for OLE DB provider 'VFPOLEDB'.
OLE DB error trace [Non-interface error: Provider not registered.].
......

In the EnterPrise Manager I can see that InterfacE is added in Linked
Servers, but when opening the table I get the following message

error 7403 : Could not locate registry entry for OLE DB provider VFPOLEDB
OLE DB error tree [non-interface error : Provider not registered]

I installed the latest files (links below your signature). .....


.