Hello, guys

First of all, thank you for your answers. I checked the links you passed to me. Advantage server is a sql server. We already have msde or sql server for that. The rest of the links leaded me to file-based applications: client places a file in a directory, the server checks the directory on a regular basis, execute the command, places the result back, the client checks the directory and gather the result.

This is not what I had in mind, and anyway, I would like to see an answer to my initial question: is feasible to build a port-listening-based client-server application, using only Visual FoxPro and releasing it open-source?

To tell you the truth, at this moment the only thing I don't know is how to make the connection between those two applications. I thought using Winsock, but this means every client will have to send on a different port, and the 'server' to open a port for every client. This is a vicious circle - the server doesn't know how many clients are, so it cannot know how many ports to open.

I'd like a connection like the one in a real sql server - that server opens one single port - 3306 for MySQL, 1433 for MSSQL server. No matter how many clients are, all of them use that port.

Please help me to solve this issue and give me ideas and ERs, and I promise you I'll make this thing happen.

Thank you.