Connecting to a remote database via Winsock. Help!

Hi

A project I'm working requires database access via the Internet. We use MSDE for our database. I've got our original program using the database via an Internet connection but it's too slow, espeically with large recordsets.

I've been working on a test server/client program that uses Winsock.

The client requests data by sending parameters to the server via winsock. The server then runs a dynamically generated SQL string, gets the data and sends it as a CSV string via winsock to the client.

This works very well, and is suprisingly fast, even on a 56kbps MODEM connection.

However, I have a problem with large recordsets. If I open a large recordset, 1500 records, a lot of the records will be missing on the client end.

I've made the server send one record at a time as it loops through the recordset. I put a DoEvents in and the helped a bit, bit I still get missing data.

I've confirmed that the server is opening and sending the correct number of records, but not all of them reach the client program.

What I find is odd is that the records come through more reliably on a 100mb/s LAN that they do on a DSL/MODEM connection. This suggests to me that it can't be anything to do with winsock getting bogged down because the LAN is much faster at sending the data.

Does anyone have any ideas as to what could be causing it?

Many thanks.