How to Connect to Oracle Database
Good Morning,
I am attempting to create a data source connection to my oracle database, however am having issues making the connection. I read through the documentation and found
"To use this provider with an on-premises installation of Geocortex Reporting, you must install a driver."
What driver am I required to install and where?
Thank you
-AC
-
Hi Adam,
This is the driver that you'll need to install: https://www.nuget.org/packages/Oracle.ManagedDataAccess/
Thanks, Stefan
0 -
Thank you Stefan
-AC
0 -
Can anyone provide a working connection string? I tried almost every possible connectionstring but none are working. Sql Server is no problem. But oracle (user is is not valid, TNS:could not resolve the connect identifier specified, malformed connection string). I have installed oracle db and client software. I can connect with sql developer, ArcGIS Server, Geocortex Essentials manager, but not with workflow 5.8.0. Even tried ADO.NET as described in the help
0 -
I got it working
0 -
@Erik Kuipers? are you able to post the connection string?
0 -
We also can not connect to a oracle database.
what is the exact syntax voor oracle db connection string?
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
the databasesettings.json file is empty
these 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",
--
0 -
Hello All,
I had it working, but my latptop has crashed completely so I don't have the correct settings anymore. I tried to setup it again, but with no good result. If I find the correct config I will post it here.
Erik
0 -
Hello,
I think I have it working:
Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=esribx5026)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=*.*.com)));User Id=test;Password=xxxx;
In the select DON'T use * when there is a shape/geometry column in it. It will fail.
It is working for me (workflow/database/portal etc on 1 laptop)
Erik
0 -
That worked for me. I used:
Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bla.bla.bla.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=xyz)));User Id=abc;Password=123;
0 -
123? That's amazing. I've got the same combination on my luggage.
0
Please sign in to leave a comment.
Comments
10 comments