We help IT Professionals succeed at work.

Date at the server

Alexey090397
Alexey090397 asked
on
Medium Priority
151 Views
Last Modified: 2010-04-04
Is it possible to get current data from a Server and put it data as a current to the Client computer ? If it possible then help me, please, how can I do it ?
Comment
Watch Question

Commented:
Could you be more specific whether it is a NT server or a Netware server. You can do this with both types of servers.
Alexey, I'm understanding your question to mean "Can I get the current DATE from the server" correct? If so, here is the SQL Statement to find the current date from Micro$oft SQL Server

Select GetDate()

which will return the date and time of the SQL Server.

Hope it's relevant!

Good luck with your project!
Pegasus

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
I'm adding a comment so that I can get notified when the answer is accepted or rejected, as I too am interested in whether Alexey means DATE or DATA...

JB

Author

Commented:
Thank you very much. Excuse me for an incorrect statement of a question. But I have another type of question. Could you give me an example of the program, which connect to the server (I know only IP of this server) and take current TIME. In Delphi 3.0 there is an example program - dchat.exe, but then I trying to connect with this program to the server it gives error : "Connection is forcefully rejected ". That I'm doing wrong ?
Thanks.
Alexey,

I believe you are trying to use the TCP/IP protocol to access the time on the server by connecting to a port? I don't remember what the port number is, but I DO know you can do that with DCHAT (I have done this). Do a Yahoo seach on PORT and TIME and see if you can get RFC document detailing the ports for various services. I know it's not much help but might get you going in the right direction. If needed, I'll do some further research on it.

Good luck with your project
Pegasus
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.