>>In VB it should be simply something like:
>>Using oConn As New Connection(.....)
>> ' Execute your SQL statement
>>End Using
>>The connection should be automatically disposed when code leaves the 'Using' scope.
>
>For each hit, we do from 10 to 20 SQL commands on average. So, I cannot use this approach.
Why not? Open, Execute, Close. Do it however many times are required. I don't think you will find the overhead to be as high as you fear.
Regards,
Viv
This is why I open the connection at the BeginRequest() method and close it in EndRequest().
>
>>This was using the VFPOLEDB? In that case I'm afraid, top of my head, I don't know.....
>
>Ok