HELP! Dataset DateTime field
Hello all out there,
I have a distributed aplication with SQL Server Desktop engine as the data store. It is basically a three-tier application distributed using .NET remoting. I use typed datasets to convey the data to the presentation tier [winforms app].
When the application [client] runs on the same machine as the SQL server, everything works fine. When it run on another machine in the network the date changes from what it is in the database.
Example
July 03, 2004 07:41:21 changes to July 03, 2004 15.41.21 on remote machine.
July 02, 2004 19.00.07 changes to July 03, 2004 03:00:07 on remote machine.
The difference ranges between 6 and 8 hours.
What could be the cause?