Load Ingest Data
Results 1 to 3 of 3

Thread: Informix configuration issues on the Windows platform

  1. #1
    Adeeb Mass'ad is offline Support Manager
    Join Date
    Aug 2006
    Location
    Jaffa of Nazareth
    Posts
    169
    Rep Power
    14

    Informix configuration issues on the Windows platform

    DESCRIPTION
    1. Informix Client is installed on the Windows platform.
    2. The user configured an Informix DataSource consuming the local Informix Client.
    PROBLEM 1

    Testing the Informix DataSource in Studio (or nav_util) caused the following error message:
    [J036] = client.requestError (query.testDatasource):
    DRV_InitTdp: DBTYPE.C (474): ; The specified module could not be found.
    ; at FIND_IMAGE_SYMBOL
    DBTYPE.C (7): ; [C079] Failed to load dynamic library 'nvdbinf'
    DBTYPE.C (10): ; PATH = ...

    DBTYPE.C (8): ; [C077] Could not find symbol 'INFORMIX' in dynamic library
    SOLUTION

    The error occurs when the Attunity Server's Informix driver could not locate the Informix modules (DLLs).

    Add the .\bin directory of the Informix Client's root directory to the Windows SYSTEM PATH, and restart the daemon. The Informix Client may be installed at the following location (add the bin directory):
    C:\Program Files\Informix\Connect\bin
    Last edited by Adeeb Mass'ad; 02-09-2007 at 10:51 AM.
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  2. #2
    Adeeb Mass'ad is offline Support Manager
    Join Date
    Aug 2006
    Location
    Jaffa of Nazareth
    Posts
    169
    Rep Power
    14
    PROBLEM 2

    If the PATH is correct and the user is still getting the following error message:
    The ordinal 607 could not be located in the dynamic link library
    System error #182 (0xb6); at FIND_IMAGE_SYMBOL
    [C079] Failed to load dynamic library 'nvdbinf'
    PATH = ...

    [C077] Could not find symbol 'INFORMIX' in dynamic library

    SOLUTION

    This could mean that the wrong Informix driver DLL is being used. The Attunity Server is bundled with two Informix DLLs:-
    • nvdbinf.dll
    • nvdbinf9.dll
    The default is the Informix 7 driver. In order to work Informix 9 and newer you have to manually copy the driver as follows:-
    1. Shutdown the Attunity Server daemon.
    2. Rename the nvdbinf.dll to nvdbinf7.dll. The driver is located at the NAVROOT\bin directory.
    3. Copy the nvdbinf9.dll to nvdbinf.dll.
    4. Start the daemon.
    5. Retest the scenario.
    Last edited by Adeeb Mass'ad; 02-09-2007 at 10:51 AM.
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  3. #3
    Adeeb Mass'ad is offline Support Manager
    Join Date
    Aug 2006
    Location
    Jaffa of Nazareth
    Posts
    169
    Rep Power
    14
    PROBLEM 3

    The user is using the correct Informix driver and still is receiving the following error:
    Error -25596: The INFORMIXSERVER value is not listed in the sqlhosts file or the Registry.
    SOLUTION

    The error means that the INFORMIXSERVER was not found in the sqlhosts file. On the Windows platform this stored in the registry. However, the user can use the "setnet32" utility.

    The setnet32 utility is located at the INFORMIXROOT\bin directory. Run the utility and review the settings.
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •