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

[Wbhn]

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

regards

Widen

[lbendlin]

Gateways are 64bit only, and only work with 64bit ODBC system DSNs.

Microsoft Idea

VFP?  Wow. that is really old.