I have successfully set up a gateway and have working connections to 1 database in an on-premises SQL server express.
Today I created a 2nd database. Flow allows me to create a connection through the gateway, but when I try to use the connection to Get Rows I get the following error:
{
"status": 400,
"message": "The key didn't match any rows in the table.\r\n inner exception: The key didn't match any rows in the table.\r\nclientRequestId: bb881838-baf1-44c5-98d8-c671fa327804",
"source": "sql-ne.azconn-ne.p.azurewebsites.net"
}
If I run Get Tables with this connection, it returns a list of tables from database 1 instead of database 2 that the connection was configured for. When I run get rows, the connection returns a correct list of tables to choose from database 2, however it errors as above.
If i run Get Rows and hand enter a table name from database 1 (not from the pull down list) I am able to retrieve data from database 1.
So it appears that the connection for Database 2 is actually pointing to Database 1, even though on Get Rows the list of available tables is from Database 2.
I'm not sure if I need a different version (paid) version of flow to manage multiple connections to different databases or if I've configured the gateway improperly? Any help would be appreciated.