Hi,
As a temporary storage between 2 sessions of VB application, I persist a
dataset generated from an Access 2000 DB as an XML file. However when I
update, the hour part of the date fields get truncated. Only the date is
inserted back.
It can't be such a big flaw or I would certainly have found reference to
this issue in newsgroups. It's got to be a
configuration/localization/version issue. Here is the context and the
process followed.
I use VS.Net 2003, version 7.1.3088. All code is in VB.
Microsoft Jet 4.0 Oledb Provider. ODBCJT32.DLL version 4.00.6019.
ConnectionString defines only Provider and Datasource parameters
(Provider='Microsoft.Jet.OLEDB.4.0'; Data Source = 'xxx.mdb'.
Database is in Access 2000 format.
Regional Settings are French(Canada)
Application.CurrentCulture = New System.Globalization.CultureInfo("en-US").
I have a dataset with a table with a datetime column. The dataset table was
generated with the DACW from an Access Table.
The Access table is populated programatically. with SQL commands. (not
through the Dataset if that matters).
The data adapter fills the dataset table.
The dataset is persisted to a file with writexml.
Later, in another session, the dataset reads the xml file (readxml).
I try to update a copy of the access db with the content of the dataset
using the Update method of the data adapter to insert the new rows
(InsertCommand queries autogenerated by the wizard). (Both access db are
copies form the same template so they have the same schema).
The update work but only the date part of the datetime field is inserted.
Hours and Minutes are dropped. I haven't check if any update would cause
the error, the context doesn't require it for that table.
I'm puzzled. Any help would be greatly appreciated.
Francois Rioux
|
Similar Threads
