There is a very good article about using DCOM to build a CLient/Server in VFP in one of the UT Magazines. The title is something like " A poor man's database server July4 2002". The instructions are very clear and it actually works. The data is passed back as XML and converted to a cursor back at the client.
The installation is very clearly set out. I have checked this against a server on our WAN. Using the file based method by mapping the server drive and executing a select locally from an indexed 2,00,000 record table with a return of 300 records took > 300 seconds and using the Client / Server method on the same table returned the data in about 50 seconds. Check it out as the basis of your idea.
It's really cool
>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 vfp 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.
