Peter,

It appears that the class requires the VFP ODBC driver to be installed. The VFP ODBC driver is no longer a part of Microsoft Data Access Components installation since about version 2.5 and does not come installed with Windows. IMO, yet another indication of VFP step-child status at Microsoft. You have to download the VFP odbc driver from Microsoft and install it on any computer that requires it.

HTH

Elmer

>Hi to All (but I hope that MS people are reading this too and feel urged to respond),
>
>I have written a vfp-application that's installed using Inno Setup.
>It contains a feature to create a pivot table in Excel.
>The feature is disabled if Excel is not on the PC (check is done with CheckServer('excel.application').
>The pivot table is created prior to calling Excel, using vfp7\ffc\pivtable.vcx. This vcx uses vfp7\ffc\automate.vcx.
>Automate.vcx contains the custom class Automate. The class does an ODBC check on init. On client machines this check produces the message..
>
>Could not find FoxPro Files ODBC driver. Check to see if it is installed.
>
>The consequence is that the custom class is *not* instantiated and Excel can therefore not be called.
>
>Questions:
>
>Do I really have to use ODBC in order to present a pivot table to Excel???
>
>If YES, what must I distribute, and how can I activate that all automatically?
>
>If NO, is there an alternative for the pivtable.vcx?