I have linked queries in Excel that query my Local Storage. I tried to refresh them later on and kept getting can’t connect to local storage errors. I then exported a new linked query and realized the Port had changed from 56631 to 55010. Once I changed the port number on the connection properties for the old linked queries it ran fine. But that’s not automated anymore. Why does the Port keep changing and how do I get around having to change the port every time?
Local Storage is supposed to be an embedded database and is not intended to be used as a standalone database. Please try Toad Data Point viewer for this. It knows how to find and attach to local storage