HI Guys !!

Lately I've been playing around with the new CursorAdapter Class in Visual Foxpro 8.0 and I've seen that whenever I use and ADODB datasource to connect to SQL Server the class performs the following steps everytime I send a command to the server:

1 - Establishes a connection (SYN,SYN/ACK,ACK) with the server.
2 - Send's the command (SQL Bulk Data) to the server.
3 - Recieve's response from the server.
4 - Closes the connection (FIN/ACK,FIN).
5 - Socket passes to TIME_WAIT state for 4 minutes, before being available again.

As you may have noticed, after the connection is closed, the socket enter's a TIME_WAIT state (as expected by any TCP connection). The problem is that my middle-ware components are creating/closing to many sockets (one per each command sent to the database server) that are being left in a TIME_WAIT state.

I understand that this is a pretty efficient way To interact with the DB server when you have multiple clients connected directly to the Database Server because the server avoids having to hold any unnecesary connections. But since I only need one connection to the database (the one used by my middle-ware components) I would like it to be a persistent connection. Is there anyway to achieve this using the cursor adapter class?

Thanks in advance...