OLE DB or ODBC error on calculated columns that only occurs occasionally

[Anonymous]

Hi,

I have multiple calculated columns in my report, and most of the time they load with no problem. Occasionally, the error "OLE DB or ODBC error" comes up on some of these calculated columns. This sometimes occurs when I write a new calculated column, or when I refresh the data. After trying to refresh the data again, the columns sometimes loads with no problem again (not always). I don't understand why this problem only occurs occasionally and don't know how to fix it.

Thank you!

[amitchandak]

@Anonymous , to me, seems like there is an issue with connectivity. or increase the timeout