Forum Discussion

samohtfrd's avatar
samohtfrd
Regular Visitor
9 years ago
Solved

gateway error invalid string or buffer length

Dear all,   I am trying to connect my 32bit VFP database to the 64 bit enterprise gateway. As I have learned this isn't possible without any passthrough I tried using Easysoft's ODBC-ODBC bridge. I...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi samohtfrd,

    I am afraid that you are not able to connect to 32bit VFP database from Power BI enterprise gateway. You install 32 bit driver in your scenario, right? In Power BI, the 64 bit gateway can only leverage 64 bit drivers.  There is a similar thread for your reference.

    To work aournd the issue, you can connect to VFP database from Power BI Desktop, create reports in Desktop, refresh data in power BI Desktop and re-publish the Power BI Desktop file each time you make changes in VFP database.


    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi samohtfrd,

I am afraid that you are not able to connect to 32bit VFP database from Power BI enterprise gateway. You install 32 bit driver in your scenario, right? In Power BI, the 64 bit gateway can only leverage 64 bit drivers.  There is a similar thread for your reference.

To work aournd the issue, you can connect to VFP database from Power BI Desktop, create reports in Desktop, refresh data in power BI Desktop and re-publish the Power BI Desktop file each time you make changes in VFP database.


Thanks,
Lydia Zhang