Provider=.12.0 Data Source=*path* extended properties=dBASE IV

My gateway is installed on SRVFILES and my Foxpro database too (I'm not 100% about it, I need to ask the person who manages this database, I'll do it next monday if I don't solve my problem before).įor the data source under the gateway, I put OLE DB as 'data source type' and here is my connection string : I actually got 3 different servers, SRVAPP1, SRVAPP2 and SRVFILES, I can reach data from both SRVAPP1 and SRVAPP2. Yes, I tried it and if I'm not wrong ODBC isn't working anymore and OLE DB is only available in 32 bit version (I installed it and I could see it on PBI 32 bit but not in PBI 64 bit). I hope that someone can help me and that everybody understood my problem, English isn't my first language, I did my best to explain this. I saw that there is a lot of drivers like Advantage Database from iAnywhere or Devart ODBC Driver but none of them work for me, maybe I do something wrong. I'm searching for a solution since 2-3 weeks and I didn't find any, the only good advice I found is to check if the ports are open, but I've no idea of which ports. I tried to read my data by intalling Power BI Desktop on the server and it worked, so I don't think that I have a connection problem between my computer and the server. I installed my driver on my server ( exactly like I did for all the others drivers I use) and when I try to create the data source for the gateway I have an error. Then I found the '.12.0' Driver, which works, I can read my data in Power BI, but I can't properly use the data gateway and I need it. Firstly I tried using the basic ODBC and OLE DB Drivers, but they are both in 32 bit and I need to work with the 64 bit version of Power BI. I need to access a Visual FoxPro database in Power BI. I'm new in the Power Bi universe, I'm working with this software since 2 months, so I don't have a lot of experience.

Microsoft visual foxpro 9.0 iso