I'm trying to create a new report that connects to a SQLite 3.74 database using the OLE DB Provider from Cherry City Software (https://cherrycitysoftware.com/CCS/Providers/ProvSQLite.aspx) but everytime I try to connect to the database Crystal Reports Crashes. Doesn't appear to matter what database I choose, it just always crashes the whole program.
Is there a way I can connect via OLEDB to a SQLite database in Crystal 2008 SP3? I also tried using ODBC drivers but whenever I select the database it doesn't show me any tables but rather just "Add Command."
Thanks,
Nick