I need to access data via ODBC in a Power Automate flow. There isn't a connector for this in Power Automate Cloud, but it can be done in Power Automate Desktop. So I've created a PAD flow that handles the ODBC connection, installed this on a VM in Azure, and added an action to call the PAD flow from my Cloud flow in unattended mode.
The PAD flow works fine when run directly on the VM. But when I sign out of the VM and attempt to run it from the Cloud flow I get this error:
"code": "Database.ConnectToDataSourceError",
"message": "Problem while executing action 'Connect'. Can't connect to data source ERROR [08001] Cannot find all files in data path\r\nERROR [01000] The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 28.1\r\nERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed\r\nERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr)
This seems to imply some sort of ODBC driver problem that occurs only when the PAD flow is called from the Cloud flow - not when it's run directly. Is that reasonable? Can anyone help please?
