on-premise WF5 cant connect to oracle database

was posted at reporting but its about WF5 on-premise install

we cant connect to a oracle database

we dont use the databasesettings.json file, the file is empty

what is the exact syntax voor oracle db connection string without using the databasesettings.json

this dont work:

SERVER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxx)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=xxx)(SERVER=DEDICATED)));User Id=read_only;Password=<xyz>;

and this aslo dont work:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxx)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=xxx)(SERVER=DEDICATED)));User Id=read_only;Password=<xyz>;

--

The Oracle.ManagedDataAccess.dll (version 19) has been copied to

\Latitude Geographics\Geocortex Workflow\Deployment\service and rycled the

GeocortexWorkflow application pool

 these are the errors:

"start": "2019-06-03T10:44:01.7902299Z",

 "end": "2019-06-03T10:44:03.6512242Z",

 "traces": [

  "Error: 0: Unexpected Error:

Geocortex.Workflow.Runtime.Execution.Exceptions.ActivityExecutionException:

[WF: Activity execution error] Failed to execute activity 6 with action gcx:wf:server::SqlQuery:

'SERVER' is an invalid connection string attribute --->

System.ArgumentException: 'SERVER' is an invalid connection string

attribute",

  "  at

OracleInternal.ConnectionPool.ConnectionString.SetProperty(String key, String

value, String quotedValue, String originalKey, SecureString secPasswd)",

  "  at

OracleInternal.ConnectionPool.ConnectionString.Parse(String constr)",

  "  at

OracleInternal.ConnectionPool.ConnectionString..ctor(String constring,

OracleCredential credential)",

  "  at OracleInternal.ConnectionPool.ConnectionString.GetCS(String

constr, OracleCredential credential, Boolean bCreateIfNotinCache)",

  "  at

Oracle.ManagedDataAccess.Client.OracleConnection.set_ConnectionString(String

value)",

  "  at Geocortex.Workflow.Server.Activities.SqlQueryBase.GetDbConnection(String

provider, String connectionString, String action)",

  "  at

Geocortex.Workflow.Server.Activities.SqlQueryBase.Execute(IDictionary`2 inputs,

IActivityContext context)",

  "  at Geocortex.Workflow.Runtime.Execution.ActivityContext.ExecuteActivityHandler(IActivityHandler

handler, IDictionary`2 inputs)",

  "  --- End of inner exception stack trace

---",

  "  at

Geocortex.Workflow.Runtime.Execution.ActivityContext.ExecuteActivityHandler(IActivityHandler

handler, IDictionary`2 inputs)",

  "  at

Geocortex.Workflow.Runtime.Execution.ActivityContext.ExecuteFinish(IActivityHandler

handler, IDictionary`2 inputs)",

  "  at

Geocortex.Workflow.Runtime.Execution.ActivityContext.ExecuteStart()",

  "  at Geocortex.Workflow.Runtime.Execution.AmbientState.ExecuteCurrentContext()",

  "  at

Geocortex.Workflow.Runtime.Execution.AmbientState.Execute()",

  "  at

Geocortex.Workflow.Runtime.Execution.Engine.Run(Program program, RunOptions

options)",

  "  at Geocortex.Workflow.Hosts.Server.Host.RunWorkflow(String

workflowJson, IDictionary`2 inputs, IDictionary`2 trivia, CancellationToken

cancellationToken)",

  "  at

Geocortex.Workflow.Server.Foundation.WorkflowRunner.ProcessAsync(Object

content)"

 ]

} 

---

"start": "2019-06-03T11:46:50.8951548Z",

 "end": "2019-06-03T11:46:50.8995457Z",

 "traces": [

   "Start",

   "Error: 0: Unexpected Error:

Geocortex.Workflow.Runtime.Execution.Exceptions.ActivityExecutionException:

[WF: Activity execution error] Failed to execute activity 6 with action

gcx:wf:server::SqlQuery: '(DESCRIPTION' is an invalid connection string

attribute ---> System.ArgumentException: '(DESCRIPTION' is an invalid

connection string attribute",

--