Ray,
I believe that your problem lies in the command where you send a "use engines" command to FoxPro. You do not need to do this with ODBC. When you create an ODBC data source you specify the .DBC or directory to use. The driver handles the rest.
It seems like the first call is leaving residual junk and the second one is picking it up.
Hope this helps.
Rod
Rod Paddock
Editor in Chief CoDe Magazine
President Dash Point Software, Inc.
VP Red Matrix Technologies,Inc.