In the ODBC source administrator/Visual Foxpro Tables/configuration, I have no path. When the Crystal Reports designer previews a report with ODBC tables, it askes me for the path and works fine.
In this same situation, when I runs the report from a form using the OCX (addressing the tables with .datafiles()) it gives me an error 20599 Cannot find SQL server.
If I put any path in ODBC source administrator/Visual Foxpro Tables/configuration like "C:\" (that is not the right path) the report trough the OCX runs fine but the Crystal report designer doesn't ask me for the path and obviously doesn't find the tables.
Is it possible to leave the ODBC source administrator/Visual Foxpro Tables/configuration without any path and give some call to connect to the ODBC driver correctly before running the report trough the OCX ?.