Franz-
>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?
Did you get a solution to this? FWIW, I'm using the provider from an ASP.NET app and updating a DateTime field just fine.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only