There is:) However I don't have time to test just now, sorry. Tonight I'll try.
Cetin
>I'm not sure if there is connection pooling for OleDb, I know there is for SQL. I just tried some sample code (using a Web Service called from a WinForm) and I couldn't see any problem when connections were closed correctly. The connection did not seem to be pooled, or at least if it was it still didn't prevent me from opening the table in VFP exclusively. I was using a free table rather than a table in a DBC, don't know if that makes any difference or not.
>
>~~Bonnie
>
>
>
>>>I just found that an ASP.NET application is locking DBF files as soon as we use them. I can go in VFP and use the table exclusive as long as I don't start my ASP.NET application. As soon as I did one hit on that site, I can no longer update the structure of my DBF. I have to reboot everytime I want to update the structure. Is this normal?
>>
>>Michel,
>>I believe it's related with connection pooling in IIS.
>>Would you try adding:
>>OLE DB Services = -2 (or -4)
>>to your connectionstring.
>>Cetin