Mohan_Raju
asked on
I would like get the data from sql server TCP port 1433 using winsock control
code
Private Sub Form_Load()
winsocktest.Protocol = sckTCPProtocol
winsocktest.LocalPort = 1433
' winsocktest.Listen
End Sub
Private Sub winsocktest_ConnectionRequ
winsocktest.LocalPort = 1433
winsocktest.Accept requestID
End Sub
Private Sub winsocktest_DataArrival( ByVal bytesTotal As Long)
Dim sItemData As String
winsocktest.GetData sItemData, vbString
MsgBox sItemData
End Sub
I want some vb code to get remote data and localhost data in binary format
Thanks in advance,
Mohan
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I use TCP and IP address to connect SQL Server using ADO like Azea mentioned.