[Bug] shared_odbc with on-prem fails pointing to placeholder URL

[josephdouce]

Describe the bug

When trying to use a shared_odbc connection, the route fails with the error

{ "success": false, "error": { "message": "{\"error\":{\"code\":502,\"message\":\"The remote name could not be resolved: \\u0027odbc.connector.com\\u0027\",\"source\":\"Removed.09.common.uk.azure-apihub.net\",\"path\":\"forward-request\",\"policyId\":\"\",\"clientRequestId\":\"Removed\",\"dreeSet\":\"true\"}}", "status": 502, "requestId": "Removed" } }

It seems the connector is pointing to a generic odbc.connector.com and not being re-routed.

gateway is correctly configured ion config.json

Steps to Reproduce

use dataflows to create an odbc connection

add connection to code app, use npx pa connection list to find the id
run npx pa connection list-datasets
run npx pa connection list-tables

Expected behavior

Return tables/data

Actual behavior

Error