1 Reply Latest reply: Jul 25, 2012 9:54 AM by Kgronau-Oracle RSS

    Unable to connect to informix unsing dg4ifmx

    Abdelouahab
      I had the following error when trying to connect to informix DB unsing Gateway :

      ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
      [Oracle][ODBC Informix Wire Protocol driver][Informix]36171 {HY000,NativeErr =
      -25571}[Oracle][ODBC Informix Wire Protocol driver]File not found '.odbc.ini'.
      {HY000,NativeErr = 1509}[Oracle][ODBC Informix Wire Protocol driver]Invalid
      attribute in connection string: ArraySize. {01S00}
      ORA-02063: preceding 2 lines from INFORMIXLN

      this is initdg4ifmx.ora :

      HS_FDS_CONNECT_INFO=IfmxHost:1433/test1150/val91
      HS_FDS_TRACE_LEVEL=OFF
      HS_FDS_RECOVERY_ACCOUNT=RECOVER
      HS_FDS_RECOVERY_PWD=RECOVER

      HS_FDS_TRACE_LEVEL=DEBUG
      HS_FDS_TRACE_FILE_NAME =dg4ifmx_trace.trc

      waiting for U
      thanks.
        • 1. Re: Unable to connect to informix unsing dg4ifmx
          Kgronau-Oracle
          I assume you want to connect to an IDS daabase.

          According to IBM the error means:
          -25571 Exceeded the maximum number of user threads.

          Check the value of the USERTHREADS parameter in the ONCONFIG configuration file and the value of the userthreads field of the NETTYPE parameter.
          -25571 Cannot create a user thread.

          The database server cannot create or spawn a user thread for a client that is trying to establish a connection.

          Probable causes of the error and corrective actions include:

          The database server cannot allocate system resources for the user thread at the moment. The client can retry the connection later. When other clients finish their work, some system resources should become available again. Check to see if the user is the right person to execute the utility or the program. For information about who can use what utilities, refer to the Trusted Facility Manual or your Administrator's Guide.

          A user who is not allowed to use a particular client application to connect to the database server tried to use the utility to connect. Client applications include SQL APIs, DB-Access, and all the database server utilities.

          A request for a Global Language Support (GLS) structure failed. Refer to the corrective actions for errors -23100, -23101, -23102, -23104, -23108, and -23110 for possible solutions.

          A user attempting to connect to the database server does not belong to the database server user group, as defined in $INFORMIXDIR/dbssodir/seccfg on a UNIX system or in the registry on a Windows NT system. Make sure that the user belongs to a user group that can access the database server. For more information about DBSSO users, see the Trusted Facility Manual.



          Can you connect with any other Informix tool from this machine to the Informix database?

          Edited by: kgronau on Jul 25, 2012 4:52 PM