11 Replies Latest reply: Sep 18, 2017 9:52 AM by scott wang RSS

    UDC ODBC Oracle. Connection String - The operation has timed out.

    Mykhailo Prosianyk

      Hello,

       

      I am working on the creation of UDC passing by ODBC Oracle.

       

      System DSN is configured and I see this DSN in the HUB when I want to make a new connection.

      It works.

      I suppose that I have a problem in Visible Connection String or in User Table Name, Attributes Table name

      Capture1.JPG

       

      Tables Oracle:

      Capture2.JPG

       

       

      Driver name comes from windows ODBC DATA SOURCE ADMINISTRATOR ( 64 bit) => Drivers

      UID and PWD it is an identifier for my database

      DBQ it is the name of my ODBC Data Source, this name is the same in tnsnames.ora

       

      I tested also a set of User Table Name and Attributes Table Name

       

      • [SCHEMA.USER_UDC]
      • [SCHEMA.”USER_UDC”]
      • SCHEMA.”USER_UDC”
      • USER_UDC
      • SCHEMA.USER_UDC

       

      It changes nothing. I have the same message. The operation has timed out and UDC is not operational.

       

       

      Thanks in advance for your help and any suggestions,