Hello, we're doing ADO inserts into a standalone VFP table with parameterized queries for every field. The datatypes are character, integer, datetime, and memos. All works great (including memo fields!) -- except for the fact that the datetime values have the 'time' portion truncated off, resulting in MM/DD/YYYY 12:00:00 AM.

As a test, I modified the calling application to connect to SQL Server OLEDB provider (instead of the VFP8 OLEDB provider) with the exact same code and table structures in place.

This works fine with SQL Server - ie., the DateTime is properly populated - including the time portion.

Anybody else seen this? The OLEDB driver is the VFP8 SP1 version: 8.0.0.3117. Perhaps there is an esoteric provider setting I can specify in the ConnectionString?

Thanks,

Franz Nisswandt