Visual Foxpro Database3/12/2021
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.Then I found the Microsoft.ACE.OLEDB.12.0 Driver, which works, I can read my data in Power BI, but I cant properly use the data gateway and I need it.
Visual Foxpro Database Driver On MyI 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. I tried to read my data by intalling Power BI Desktop on the server and it worked, so I dont think that I have a connection problem between my computer and the server. ![]() 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 hope that someone can help me and that everybody understood my problem, English isnt my first language, I did my best to explain this. Yes, I tried it and if Im not wrong ODBC isnt 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 actually got 3 different servers, SRVAPP1, SRVAPP2 and SRVFILES, I can reach data from both SRVAPP1 and SRVAPP2. My gateway is installed on SRVFILES and my Foxpro database too (Im not 100 about it, I need to ask the person who manages this database, Ill do it next monday if I dont solve my problem before). Masquer les dtails: Cant connect, we encountered an error while trying to connect to. Details: We were unable to publish this data source for the gateway instances of this cluster. Make sure the path is correct and that a connection is made with the server where the file resides. ProviderPCSoft.HFSQL;initial catalogDBname;data sourceSRVAPP2:4900;extended propertiesLanguageISO-8859-1;Password:------; Best regards, Alexandre Wahl.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |