So, everything works. There is a chance that you have configured something wrong for yourself. It may also be that you configured everything correctly, but encountered this problem:
It could create an error when you switched from a local target to hosting, but did not update the dependency schemas in the server action tables.
I show the result of simultaneous connection to different databases for different purposes and settings:
A few words about setting up the connection. As you can see from the video, at the beginning I have a connection to the local database. And the Direct Connection function is enabled in the settings. This feature allows you to manage the database directly from the Wappler database Manager. But on your hosting there is a restriction on external connection. So when I show the settings for connecting to the hosting database, this feature is disabled.
The video also doesn't show the process of redefining dependency schemas. But this is a simple process. If you created a server action on, say, a local target, then when switching the target to hosting, you should go to this server action and you will see a warning window that you should define the schema. After you update the scheme, you can upload the site to hosting and everything will work.