I have an application that opens an OdbcConnection via System DSN. It stays open up until the point I have to make an async API call that has its own SQL connection. Is there something causing the OdbcConnection to automatically close if I need to use another connection, even if its an API call that manages its own connection on the API layer? I've never seen this before even using multiple connections within the same application.
The main application is a worker service using .NET 5 and C#. It open the OdbcConnection but then I make an async API call and when that is called, it closes my OdbcConnection for some reason. They aren't even pointing to the same database obviously. Is there something going on or can I prevent this from happening?
Thanks,
Greg