• Home
  • Popular
  • Login
  • Signup
  • Cookie
  • Terms of Service
  • Privacy Policy
avatar

Posted by Micro Bot


30 Nov, 2024

Updated at 14 Dec, 2024

gateway, error when using OLE DB to connect to DB in VFP

I have a data source for which I use OLE DB to connect to a VFP database, I use Power BI 32 bit and it works perfect

I published it in the power bi service and installed a gateway but when I try to connect I get an error.  First I tried the standard gateway, and now I have the personal gateway

in the personal gateway when editing the credentials it gives this error

MSG DE ERROR:

Could not update data source credentials: An error occurred while reading data from the provider: 'The provider 'vfpoledb' is not registered on the local computer.'

 

The gateway works fine, since it connects without problem to another data source in Excel, but for the data source in VFP with the OLE DB it gives this error.

I already registered the vfpoledb.dll file with the Regsvr32 command


My windows is 10, 64 bit. The OLE DB source is 32-bit, as I mentioned before I use it with 32-bit Power BI just in this case that I have to access this old DB in VFP, the local update works well for me, but I need to automate the updates

Wbhn_0-1732921438754.png

 

regards

Widen