Forum Discussion

wonga's avatar
wonga
Continued Contributor
10 years ago
Solved

Oracle Data Source in Enterprise Gateway

I'm having trouble adding an Oracle database as a data source in the enterprise gateway. The error message I get is below:   Unable to connect: We encountered an error while trying to connect to SE...
Need Help
  • wonga's avatar
    wonga
    10 years ago

    Hi dimazaid, I managed to solve this by using the Oracle service name found in tnsnames.ora instead of using the full hostname.

     

    So instead of putting "HOSTNAME" in the "Server" field, all I had to do was put in the service name. For reference, the syntax of a tnsnames.ora entry is:

     

    SERVICENAME =

      (DESCRIPTION =

        (ADDRESS = (PROTOCOL = TYPE)(HOST = HOSTNAME)(PORT = PORTNUM))

        (CONNECT_DATA =

          (SERVICE_NAME = SERVICENAME)

       )

      )

     

    Thanks, I forgot to mark this one as solved!

dimazaid's avatar
dimazaid
Microsoft Employee
10 years ago

hi wonga,
Could you try using your own account to use the Gateway? and refresh again. 
If that works, you should reinstall the oracle components in a way that ensures the service account for the Gateway has access to them.

wonga's avatar
wonga
Continued Contributor
10 years ago

Hi dimazaid, I managed to solve this by using the Oracle service name found in tnsnames.ora instead of using the full hostname.

 

So instead of putting "HOSTNAME" in the "Server" field, all I had to do was put in the service name. For reference, the syntax of a tnsnames.ora entry is:

 

SERVICENAME =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TYPE)(HOST = HOSTNAME)(PORT = PORTNUM))

    (CONNECT_DATA =

      (SERVICE_NAME = SERVICENAME)

   )

  )

 

Thanks, I forgot to mark this one as solved!