>>You should always close a connection as soon as possible (and open it as late as possible). The simplest way to achieve this is probably to wrap it in a using{} block. If you have connection pooling enabled (the default) it shouldn't affect performance.
>
>Can you provide an example of using{} block?
In VB it should be simply something like:
Using oConn As New Connection(.....)
End Using
The connection should be automatically disposed when code leaves the 'Using' scope.
>
>>If you're *not* closing connections it could account for the performance issues you were experiencing - they'll be hanging around until the GC gets to them. Did you monitor the number of open connections?
>
>Where can I go to see that?
This was using the VFPOLEDB? In that case I'm afraid, top of my head, I don't know.....