Adding WorkAround =536870912 in the connection string in Key Vault

Kumar, Arun 296 Reputation points
2024-04-11T16:45:32.1933333+00:00

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>>;"
Azure Key Vault
Azure Key Vault
An Azure service that is used to manage and protect cryptographic keys and other secrets used by cloud apps and services.
1,118 questions
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
9,089 questions
{count} votes