Skip to main content

How to Connect to Oracle Database

Comments

10 comments

  • Stefan Schweigert

    Hi Adam,

     

    This is the driver that you'll need to install: https://www.nuget.org/packages/Oracle.ManagedDataAccess/

     

    Thanks, Stefan

    0
  • Permanently deleted user

    Thank you Stefan

    -AC

    0
  • Permanently deleted user

    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
  • Permanently deleted user

    I got it working

    0
  • Bryan Bingham

    @Erik Kuipers? are you able to post the connection string?

    0
  • K L

    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
  • Permanently deleted user

    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
  • Permanently deleted user

    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
  • Mike Diss-Torrance

    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
  • Gareth Evans

    123? That's amazing. I've got the same combination on my luggage.

    0

Please sign in to leave a comment.