I am having some strange problems with the OleDb provider occasionally. Basically, I just got another error. The message was:

"Variable 'NUMERO' is not found."

And, this was the SQL:

SELECT Province.Title_E AS Name,Province.Numero AS PrimaryKey FROM Province ORDER BY 1

This is a very simple SQL. The field Numero does exist. I was on the page that was using that SQL. But, when I tried to refresh it, I got this message. Then, I retried and it was ok. I retried several times and it was always ok. This is happening occasionnaly and I just can't find where this is coming from.

Is the OleDb provider reliable or not?