Hi
I have developed a C# web service that uses a VFP MTDLL to access my SQL Server database. The web service works fine.
The problem I have is that whenever I call into the DLL, I open a new connection, Read/Write to SQLServer and then return to the Web Service. I don't use the session object but pass a session id string I generate. After a few calls to different methods in the Web Service which in turn calls into the VFP MTDLL, I find that although the calls have completed, IIS keeps all the connections open and the only way to release them is to do a IISRESET.
Since I dont use sessions I was under the impression that once the call into the DLL was complete, it would be released from memory and the connections would be closed automatically. But this is not so. IIS keeps them all open even when I close the page that calls the web service.
I can close the connections manually but I thought that being stateless they would be released once the call was complete.
Is there some setting to avoid this multiple connection or do I have to close each connection manually just before I return from the Function call?
Bernard