Does FireDAC work with Foxpro files and CDX files? The component we have been using "Apollo" seems to be dead. Any recommendations?

-
Does FireDAC work with Foxpro files and CDX files? The component we have been using "Apollo" seems to be dead. Any recommendations?

Thanks,

Comments

  1. Lars FosdalDecember 15, 2018 at 12:42 PM

    Do you have a version of Apollo that works with an older Delphi? Recreate the dB in Firebird and migrate the data, reading with Apollo and writing with FireDAC.

    ReplyDelete
  2. Lars FosdalDecember 15, 2018 at 12:44 PM

    Or...
    https://forums.embarcadero.com/thread.jspa?threadID=246789
    forums.embarcadero.com - Embarcadero Discussion Forums: Delphi 10.1 is there a way to access ...

    ReplyDelete
  3. Tuan DamDecember 15, 2018 at 3:44 PM

    Thanks Lars Fosdal. I believe Advantage Database Server is probably the best solution. I remember using them before on another project and it seems to work well. There are modifications to source that is "supposed" to let it work with 10.3.

    Anyone successful in getting ADS to work with 10.3?

    ReplyDelete
  4. Francisco Armando Dueñas RodríguezDecember 15, 2018 at 4:24 PM

    Also Halcyon DBF should work for you. BTW why do you still use DBFs? Is it because your are using another software that uses DBfs? If not, sqlite is an option to go

    ReplyDelete
  5. Francisco Armando Dueñas RodríguezDecember 15, 2018 at 6:34 PM

    fireDAC can work with ODBC si yo you can install foxpro odbc or latest oledb driver (using ODBC for oledb) and call it with fireDAC. ODBC seemw no longer active but you can get latest oledb. You can download foxpro odbc/oledb here: https://docs.microsoft.com/en-us/previous-versions/visualstudio/foxpro/mt490121(v=msdn.10)

    ReplyDelete
  6. Tuan DamDecember 15, 2018 at 7:48 PM

    Does the ODBC support CDX files?

    ReplyDelete
  7. Dmitry ArefievDecember 16, 2018 at 1:05 AM

    With FireDAC the best solution will be to use FireDAC Advantage driver. Advantage also has free local engine.

    ReplyDelete
  8. Mike ShkolnikDecember 16, 2018 at 5:13 AM

    You may use the ADO connection with provider for FoxPro:
    microsoft.com - Microsoft OLE DB Provider for Visual FoxPro 9.0

    ReplyDelete
  9. Francisco Armando Dueñas RodríguezDecember 16, 2018 at 5:34 AM

    Tuan Dam yes. But ODBC driver seems to be discontinued. So the foxpro oledb driver is the way to go. It can be consumed withe 'ODBC for oledb driver' that should exist already in your windows. But as Dmitry said , maybe using the free advantage database driver for local connection and firedac's advantage driver could help you more.

    ReplyDelete
  10. Wilma JohnsonDecember 17, 2018 at 8:19 AM

    Concerning Advantage Database, SAP is no longer supporting their components (as far as I know) though there are fireDac drivers for ADS database. With the components, it wasn't necessary to install ADS database. Advantage is the best for working with the "XBase" file formats

    ReplyDelete
  11. Richard BaroniunasDecember 17, 2018 at 8:23 AM

    Tuan Dam You may be putting yourself into a corner by going with SAP ADS, the Delphi support is ok but limited. You can easily get the last version of Foxpro, export the content into something that may be viable for other DBMS. The last Foxpro version was V9.X and should be a free download but I am unsure if it works on Win10, it did work on Win7 since i have it on my notebook.

    You also have the option of importing the content into MS Access and if you know the index structure can easily rebuild the indexes instead of importing the CDX.

    Depending on the data and the clients as well as the usage you do have options on the table. You can use MySQL or Firebase which are free solutions as well as purchasing MS SQL but once again you need to come up with a solid plan for how and what you are using the data for.

    ReplyDelete
  12. Tuan DamDecember 17, 2018 at 8:36 AM

    The problem I have is the dependency on the dbf format used by a legacy system. Otherwise, I would have converted this years ago.

    I read that SAP is coming out with an version that will work? Also, there is a workaround to making it work with 10.3 based on what I read in the community forums.

    ReplyDelete

Post a Comment