In our current project we are working with 2 databases.
I have both added them in the connections manager and tested their connection, so far so good.
Next I added a table from database A into the DA schema modeler and a stored procedure (as a command) from database B.
These are both showing up correctly, they have both 1 statement with the correct connection filled in in the schema modeler.
In the connections manager you always (?) have a default connection, in my case this was the first database added (‘A’).
When trying out the client, retrieving values from the table in DB A was working as expected.
However, executing the command failed with the message “Could not find stored procedure…” .
When setting the default connection to DB B, the situation is reversed, I cannot get any values from the table in DB A, but can execute the command (the stored procedure) on DB B.
From looking around the table/command should be using the connection defined in the statement, but it seems it is always using the default connection.
Is my thinking correct? Or am I missing something?
I am using Visual Studio 2019 and DA 10.0.0.1463.
Thanks in advance!