Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFPOLEDB.DLL V8 SP1 DateTime Problem
Message
From
07/03/2004 19:48:55
 
 
To
26/02/2004 15:55:22
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00881241
Message ID:
00883963
Views:
25
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
Map
View

Click here to load this message in the networking platform