Solved

VB6 Telnet Winsock Run-Time Error '40006'

Posted on 2010-08-18
10
1,631 Views
Last Modified: 2012-05-10
I am using the following code -

Private Sub Connect_Click()
    Winsock1.Connect ("192.168.1.1"), 23
    Winsock1.SendData "admin" & vbCrLf
End Sub

and basically get the error - Run-Time Error '40006'

I can avoid this error by having two seperate buttons, one to connect and one to issue the SendData command, or by using the following function -

Private Sub Winsock1_Connect()
   Winsock1.SendData "admin" & vbCrLf
End Sub

But I do not want to use either of these methods, I just want everything to be included in the one button.

Please help!
0
Comment
Question by:souldigital
  • 5
  • 4
10 Comments
 
LVL 17

Expert Comment

by:Zhaolai
ID: 33470184
You have to wait for the connection to be completed before sending data.
Try this:


Private Sub Connect_Click()
    Winsock1.Connect ("192.168.1.1"), 23
    Do While Winsock1.State = sckConnected
        Winsock1.SendData "admin" & vbCrLf
        Exit Do
    Loop
End Sub

Open in new window

0
 
LVL 17

Expert Comment

by:Zhaolai
ID: 33470203
Oooop, a mistake in the loop.
Try this:


Private Sub Connect_Click()
    Winsock1.Connect ("192.168.1.1"), 23
    Do While True
        If Winsock1.State = sckConnected Then
            Winsock1.SendData "admin" & vbCrLf
            Exit Do
        End If
    Loop
End Sub

Open in new window

0
 

Author Comment

by:souldigital
ID: 33470241
This loop creates 100% cpu usage and crashes VB  :-s
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 17

Expert Comment

by:Zhaolai
ID: 33470261
Aha, I don't think that the code in my above posts will work.
Please refer to the following link:

http://kbalertz.com/Feedback.aspx?kbNumber=183987

It looks like that you have to call the Connect event to send data.
Sorry for the confusion.
0
 

Author Comment

by:souldigital
ID: 33470303
This is the same as using 2 buttons, one to connect and one to execute the command, but instead of using a button to connect it does it on form load which sadly is no good.

??????????????????????????????
0
 
LVL 17

Expert Comment

by:Zhaolai
ID: 33471513
No, you don't need to have two buttons. The Connect event will fire automatically once the connection is complete.

All you need is a button to initiate the connection. See below:



Private Sub Connect_Click()
    Winsock1.Connect ("192.168.1.1"), 23
End Sub

'This event fires automatically once the connection is complete.
Private Sub Winsock1_Connect()
   Winsock1.SendData "admin" & vbCrLf
End Sub

'You may need the following event to capture any connection error

Private Sub Winsock1_Error(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 "Error occurred: " & Description, vbExclamation, "Connection Error"
End Sub

Open in new window

0
 
LVL 11

Expert Comment

by:JoeNuvo
ID: 33472048
either follow above comment by using the default event _Connect

or

if you sure that the "server" you try to connect to always ready to accept connection.
you may put some delay after you call for connect

' this code, put on top at global variable declare
Private Declare Sub Sleep Lib "Kernel32.dll" (ByVal dwMilliseconds As Long)


Private Sub Connect_Click()
   Winsock1.Connect ("192.168.1.1"), 23

    for i = 1 to 100
       sleep 1   ' try adjust number of loop, or adjust number of sleep time to match your need
       doevents
   next

    Winsock1.SendData "admin" & vbCrLf
End Sub
0
 

Author Comment

by:souldigital
ID: 33473369
Yes it will fire when the connection is complete but I need to issue different commands depending on which button I click.

Button A - Winsock1.SendData "admin" & vbCrLf

Button B - Winsock1.SendData "tx power" & vbCrLf

Button C - Winsock1.SendData "help" & vbCrLf

and so on

So I need it to connect, send the data then disconnect all in one button without using any Sub Winsock1_Connect()

I have tried a timer before with a 10second pause and it still gives the same error. It is almost as if you have to End Sub before the connection is fully established?

I can literally click connect (Button 1) then send a command (Button 2) with no delay and it works fine.
0
 
LVL 17

Accepted Solution

by:
Zhaolai earned 500 total points
ID: 33474921
Now I see why you want to have all the code in one sub... But unfortunately that's not the way it designed.
Try the following code:


Private iButton As Integer

Private Sub Command1_Click()
    iButton = 1
    ConnectWinsock
End Sub

Private Sub Command2_Click()
    iButton = 2
    ConnectWinsock
End Sub

Private Sub Command3_Click()
    iButton = 3
    ConnectWinsock
End Sub

Private Sub ConnectWinsock()
    Winsock1.Close
    Winsock1.Connect "192.168.1.1", 23
End Sub

Private Sub Winsock1_Connect()
    Select Case iButton
        Case 1: Winsock1.SendData "admin" & vbCrLf
        Case 2: Winsock1.SendData "tx power" & vbCrLf
        Case 3: Winsock1.SendData "help" & vbCrLf
    End Select
End Sub

Private Sub Winsock1_Error(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 "Error occurred: " & Description
End Sub

Open in new window

0
 

Author Comment

by:souldigital
ID: 33478214
Perfect, thanks!
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
to transfer string from C lanaguage to VBA 4 66
vb6 connector to SQL Server 2 37
VB 6 error 5 in windows 10 but not in XP 7 56
Export Data to Different .csv Files 26 105
Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question