>>I have been using the VFPOLEDB connection with ASP.NET for 5 years and I wonder if any way my app was benefitting from the connection pooling. At least with SQL Server I found an online article that has a little demo of how to "check" the connection pooling. Which I plan to do (I mean to check how it works).
>
>Please, note that it is highly not recommended to use VFPOLEDB under ASP.NET. You will get a lot of unexpected behaviors. I have created several threads on that topics a few years ago. One of them lists all kinds of errors you will get during a hit to SQL Server, errors which are totally not related at all, as they are not. But, it does cause an exception. This is why you would need to consider moving your backend asap to SQL Server if you plan to switch for the Web.
>
>Please, note that this applies only to using the VFPOLEDB data adapter under ASP.NET, thus under IIS. You have not gotten this reaction so far because you were using it under a desktop application, which is not under the IIS layer.
Not exactly correct, in my case. I do indeed use VFPOLEDB under ASP.NET (without problems) for several years because I use it with VFP data, not SQL Server. And of course, with SQL Server I will be using ODBC.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
