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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement