0

I have an ASP .NET page that calls into a MariaDB database to populate items in a dropdown list. Yesterday in the morning I was able to make changes in the database and they would show up in the dropdown (either text changes, deletions or insertions, all worked). Yesterday afternoon my changes no longer showed up, and that continues today.

Environment:

Win10 Enterprise

Visual Studio 2019 Enterprise

MariaDB 10.2.10

I have tried with four different browsers (Chrome, Edge, Firefox & Brave). I've cleared caches, I've deleted the IIS Express directory in C:\Users%username%\Documents, I've changed the port number (and seen the change show up in the resultant webpage's address). Looked for same port errors (this was a problem earlier, but solved now, see above).

Since we run with production & test database instances, I've confirmed that I'm not looking at the production instance, and the edits I've made since yesterday are still in the test instance. I've also made a minor change to one of the items in the production server and it doesn't show up either (as I'd expect it not to).

I'm running out of ideas and not sure what to try next.

How can I force IIS Express to refresh it's database calls instead of using cached data.

Improve this question
7
  • Have you tried restarting the app and recycling app pool? Have you checked that website is looking at the correct database instance? Commented Jun 28, 2023 at 18:14
  • I've restarted the app probably dozens of times, as well as rebooted my machine. I'm not sure how to recycle the app pool, but I'll Google it, and when we're using the debug instance in VS 2019 it automatically goes to the test instance (and the UI shows "Test Database" in red text so it's hard to mistake. Commented Jun 28, 2023 at 18:17
  • If you have rebooted machine with the IIS then no need to recycle app pool. Without access to the environment it is hard to tell anything particular. Commented Jun 28, 2023 at 18:23
  • 99% of the time, this happens when the code is not looking at the database instance you think it is. Verify your connection strings. Commented Jun 28, 2023 at 18:57
  • @JuanR, while that's possible, and I'll double check, I've made zero changes to the code, the only changes are in the database itself. Commented Jun 28, 2023 at 19:18
Related questions
551
How to enable external request in IIS Express?
392
Where is the IIS Express configuration / metabase file found?
326
Using Custom Domains With IIS Express
Load 6 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.