pcsoft.us.windevCopyright 2026, PC SOFT13 Dec 2019 12:00:12 Z8 Dec 2019 15:32:32 ZHi all. I need to start a Socket connection on my server to connect to an external company. However, the function SocketConnect is not available in Stored Procedures. Basically what I need to do is: My customer app connects to my Server and updates a file in C/S. Simple enough. This would trigger a stored procedure on my server which takes those details and opens up a Socket conversation with one of many companys to check availablity etc. They then reply to my server with an answer via the socket. I reply back to my user. The ideal way would be to directly connect to the Client's databases, but not all will allow that, so Socket conversations seem the best way. Problem is that my server cannot open a Socket as SocketConnect is not available in the Stored procedures on my server. The only alternative is for a stored procedure to write the required details to a HF file and then have a separate exe running on the server which is constantly reading the file and doing the socket conversation separatley. This however is a very messy way to have to do this. Any ideas would be appreciated. Simon30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67478-how-start-socket-connections-stored-procedures/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)sdbxoxpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67478-how-start-socket-connections-stored-procedures-67494/read.awp13 Dec 2019 12:00:12 ZHi Ben Thats what I am begining to think. It seems that the only way to do it is as you suggest, to load a temporary file an…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67478-how-start-socket-connections-stored-procedures-67494/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67478-how-start-socket-connections-stored-procedures-67494/read.awpHow to start Socket connections in stored proceduresbenpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67478-how-start-socket-connections-stored-procedures-67487/read.awp11 Dec 2019 07:42:24 ZHi An external process that does the connection and transfer is the only real way to do this. You do not want a socket co…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67478-how-start-socket-connections-stored-procedures-67487/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67478-how-start-socket-connections-stored-procedures-67487/read.awpHow to start Socket connections in stored procedures