>One SQL is executed several times in my aspx page. But, once it returned this following message:
>
>The ICommandText interface is not supported by the 'VFPOLEDB.1' provider. Use CommandType.TableDirect instead.
>
>That is the only time I got it. This SQL is executed on a regular basis and I am wondering what could have caused this message.
For those that are curious about it, this issue is still unresolved. For those who would like to gather information from the .NET, you will not find that much around as this is undocumented. I only found one search result for this error line on Google and it leaded to two other developers also having the same situation. This happens just like that and it is not consistent. It may work well for thousands of hits and suddently you get the error. It doesn't matter if you just SQL the data out or if you are updated/inserting. It is also not related to the provider. The other two have it on the Jet provider.