StevenK
asked on
Checking client machine Date against server Date
How can I check whether or not I have a match between my client machine (system) date and the server (system) date ?
We have seen instances when a client machine has had a different (future) date set [due to testing on a local machine for some reason] and when running Delphi code that makes use of the 'Now'/'Date' calls then inputs misleading date stamps in data on the server.
We're looking for ways to determine whether or not all our dates on machines are in line.
Can this be done ?
Thanks in advance
Steve
We have seen instances when a client machine has had a different (future) date set [due to testing on a local machine for some reason] and when running Delphi code that makes use of the 'Now'/'Date' calls then inputs misleading date stamps in data on the server.
We're looking for ways to determine whether or not all our dates on machines are in line.
Can this be done ?
Thanks in advance
Steve
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Apart from the API functions, you could run a stored procedure against your database server, in case you have one. This would be platform independent.
ASKER
As far as the database server taking control of the date / time element of things - this is kind of a no-go. :(
We're restricted to the Paradox tables that we adopted (whereas we'd now make use of SQL Server and its time-getting procedures).
Thanks anyway.
Steve
We're restricted to the Paradox tables that we adopted (whereas we'd now make use of SQL Server and its time-getting procedures).
Thanks anyway.
Steve
Maybe if you have client/server applications, then you can make the clients all send ther Now to the server application at Start. And if anybody has a different Date then server should send its own Date to her... You can do it using TClient/ServerSocket
StevenK:
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
increase points and I'll post here some code includeing date synchronization between two machines.
Note: works only on WinNT 4.0 or higher.
ziolko.