Access VBADiscuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Access VBA section of the Wrox p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.
How to bind more than one client in one computer to winsock server
How to bind more than one client in one computer to winsock server
i have 1 application server in server computer
and 5 client application in one computer. ( install 5 client in one computer )
i use oswinsck winsock UDP protocol
if only 1 client connect to server, everything well done
but if more than one client connected to server , will be errror
"Method 'Bind' of object 'IMSWinsockControl' Failed
my question is how to solve this problem
application server and application client , i made with ms.access xp
-----------
server
-----------
Option Compare Database
Dim WithEvents WsServer As OSWINSCK.Winsock
Private Sub cmdSend_Click()
On Error GoTo salah
WsServer.SendData txtUserIdJats
Exit Sub
salah:
MsgRoes Err.Description, "Test Msg"
End Sub
Private Sub WsServer_OnClose()
WsServer.CloseWinsock
End Sub
Private Sub WsServer_OnDataArrival(ByVal bytesTotal As Long)
On Error GoTo salah
Dim sBuffer As String
WsServer.GetData sBuffer
Me.List6.AddItem "Data : " & sBuffer & vbCrLf
Exit Sub
salah:
MsgRoes Err.Description, "Winsock Data Arrival"
End Sub
Private Sub WsServer_OnError(ByVal Number As Integer, Description As String, ByVal Scode As Long, ByVal Source As String, ByVal HelpFile As String, ByVal HelpContext As Long, CancelDisplay As Boolean)
MsgBox Description, vbOKOnly, "Winsock Error: " & Number
CancelDisplay = True
End Sub
---------------------
Client
---------------------
Option Compare Database
Dim WithEvents wsClient As OSWINSCK.Winsock
Private Sub Command5_Click()
wsClient.SendData Me.Text6
End Sub
Private Sub Form_Close()
wsClient.CloseWinsock
End Sub
Private Sub Form_Load()
Set wsClient = CreateObject("OSWINSCK.Winsock")
wsClient.Protocol = sckUDPProtocol
wsClient.Bind 51010
End Sub
Private Sub wsClient_OnDataArrival(ByVal bytesTotal As Long)
Dim sBuffer As String
wsClient.GetData sBuffer
Me.List6.AddItem "Data : " & sBuffer & vbCrLf
End Sub
How to bind more than one client in one computer to winsock server
Linear Mode
