by Chris Hatton (7 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 3.0
Difficulty: Intermediate
Date Added: Wed 3rd February 2021
Rating: 
(88 Votes)
Heres a good example of using a winsock control to access a ADO database over a network/dialup connection. You will be able to access the database fully, with Add/Delete, Read/Write access. Also i have inbedded authentication against the database via the winsock control.
This program is simply for basic job tracking, from inhouse, and for remote access areas.
Bascially how this works, It sends the server a few commands/strings, and the server generates the sql statement and sends back the results, to the client winsock application, it then recieves the information and displays it out into a listview control with columns.
--------------------------------If you like the code please vote!
Inputs
If anyone can share with me any Winsock API code with multi connections, i'll be happy to rewrite another program like this using only API.
email me @ [email protected]
Assumes
Multi connections to the winsock server, doesn't work that well. if you get it running successfully please email me and tell me what you did.
Download Access Ado Database Remotely via Winsock Control (91 KB)
VBcoders