How can get data and time from server database?

[mypombob]

Hi.. i was trying to make a billing program using vb6 and winsock for LAN.
and i want the ID, password and time get from the server database using the client program. Can you show me the example or simple program?
Thanks..

[RhinoBull]

Connect to your database and select necessary data directly from it. What's the problem?
If myou need sample code check out our database FAQ.

[dilettante]

I'm not sure where Winsock comes into the picture if you're using a "server database" (which I assume means "client/server database" like SQL Server vs. Jet MDBs on a file server).

[menzow]

Use PHP instead of a direct connection to the database.
For a direct connection, you would have to store the password's in your software.

The best thing you can do is just send a GET/POST request to a PHP file.
Than let the PHP file process all the data, store it in the database, receive it from the database.

And than return everything your client needs to know using
"echo" or something.

Read the return value, and present it to your client.

[dilettante]

You don't have to resort to a Web scripting system to do that.

Across LANs you can use Named Pipes, DCOM, TCP/IP, or almost anything before you resort to the overhead and extra complexity of HTTP. That means if you want a middle tier between your clients and the database you can write a VB6 program to mediate data access. DCOM would be the most "native" approach in VB6 with the best support.

Or with a LAN you can rely on Windows authentication at the database server if you use something like SQL Server that can support it. Then the user's normal Windows credentials are enough.