Adding WorkAround =536870912 in the connection string in Key Vault
All,
I am creating a copy activity to load data from SQL Server to Oracle table. Getting below error -
{ "errorCode": "2200", "message": "Failure happened on 'Sink' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY000] [Microsoft][ODBC Oracle Wire Protocol driver]Data type for parameter 8 has changed since first SQLExecute call.,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=Microsoft.DataTransfer.ClientLibrary.Odbc.Exceptions.OdbcException,Message=ERROR [HY000] [Microsoft][ODBC Oracle Wire Protocol driver]Data type for parameter 8 has changed since first SQLExecute call.,Source=msora28.dll,'", "failureType": "UserError", "target": "Copy data1", "details": [] }
When i searched in google, the workaround is to add WorkAround =536870912 in the "Additional Connection Properties" of linked service. This works if the connection values are hard coded like specifying the server name, user id, password etc. But i am connecting through Key Vault and would like to know how this can be added as part of Key Vault connection
My current Key Vault Secret value is below
"secretValue": "Host=<<server name>>;Port=100;Sid=OracleDB;User Id=<<userid>>;Password=<<password>>;"