Results 1 to 5 of 5
  1. #1
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    TCP Client (Access97)

    I need to export data to another program which I am told " listens on the TCP port 8099".

    I am told that I need to set up a TCP client that can send and receives messages on this port.

    I have also been some sample code written in Delphi (I believe) that includes things like:
    <pre> TCPClient.Connect;
    TCPClient.WriteLn('LCX:NAR:');
    </pre>


    MY questions:
    Can you create a TCP Client in VBA? How?
    If not, does anyone know of any add add-ins that will enable me to do this?
    Regards
    John



  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: TCP Client (Access97)

    I have since found an article in the knowledge base about how to do this using the
    Winsock ActiveX Control .

    I don't have Winsock ActiveX, so I am still looking for other solutions.
    Regards
    John



  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: TCP Client (Access97)

    Do you have mswinsck.ocx? That's the VB 6 version of the control.
    Charlotte

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: TCP Client (Access97)

    No I don't have that either.

    But it now seems to me that I have no choice other than to get a copy of something equivalent.

    I have just downloaded something from Easy Com that will at least give me something to try out.
    Regards
    John



  5. #5
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: TCP Client (Access97)

    Should mswinsck.ocx from vb5 work OK.

    I attach a little demo file based on an example I got from Winsock ActiveX Control . The example had three winsock controls and I couldn't get it to work so I cut it back to two.

    I have had a vast range of errors trying to get this work.

    The current version gives this error when I click the connect button " Method Accept of object IMSwinsock control failed" then goes into an endless loop that requires Ctrl & Alt & Del to close Access.

    wsClient.RemoteHost = wsListen.LocalIP assigns the IP number I was assigned when I last dialled into my ISP, so that won't work unless I am online. The VB documentation says I can use my computer's name from the Network control panel, but that doesn't work either.

    Should the example attached work? Can you suggest what to change to make it work?
    ( the attachment is in Access 2000).
    Attached Files Attached Files
    Regards
    John



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •