Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 13th, 2009, 06:50 AM
Registered User
 
Join Date: Jun 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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 Form_Load()

Set WsServer = CreateObject("OSWINSCK.Winsock")
WsServer.Protocol = sckUDPProtocol
WsServer.RemoteHost = ipserver
WsServer.RemotePort = rport

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






Similar Threads
Thread Thread Starter Forum Replies Last Post
using cookie with client computer hertendreef ASP.NET 2.0 Professional 4 December 28th, 2008 03:45 PM
How to get Client Computer Name ramuis78 ASP.NET 2.0 Basics 2 March 11th, 2007 11:48 PM
how to get client computer name ramuis78 ASP.NET 1.0 and 1.1 Basics 1 March 11th, 2007 10:21 AM
how to instal font at client computer BurhanKhan Javascript 4 April 28th, 2004 05:48 AM
VBA winsock POP email client hooi Access VBA 0 December 23rd, 2003 04:03 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.