TCP Client (Access97)

[johnhutchison]

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?

[johnhutchison]

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.

[charlotte]

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

[johnhutchison]

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.

[johnhutchison]

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).