I am getting method error 12029 in my web application which is fetching the data from the database, this error occurs when the connection to our database server cannot be established or when the page is not able to retrieve the data from the DB
Actual scenario in which this error usually occurs is:
I have got a cascading dropdown list on my page where the data into the second dropdown list is populated based on the selection done in the first dropdown. Whenever the page is left idle for some half an hour and if I try to access the data after that, this error occurs in the cascading dropdownlist. The issue gets solved if I close the page and open it again or if I try to access the page after sometime.
What should I do in order to resolve this issue?