Windows 10 - ODBC driver - libreoffice - acuxdbc03

Hi.

I'm trying to access an AcuXDBC Server through ODBC.

The tool that i am using is LibreOffice Base.

The driver configure is ODBC 64 bits, and when i click on "Test Connection" it appear the following error:

 

""[TOD][ODBC Driver]DLLLOAD: acuxdbc03, The specified module could not be found.""

 

Where could the solution go?

Thanks

Parents
  •  

    the error "library not found" usually is a symptom of a PATH environment variable not set, or not correctly set.

    Can you verify this setting in your client machine?
    It should point to both the ACU "bin" and "lib" folders, so that all the necessary libraries are available to your "libreoffice" when it attempts to establish the connection to the remote AcuXDBC Server.

  •  

    I've attached two screenshots about the environment variable PATH.

    Also, i've added the following variables to the "EnvVars" in the ODBC configuration:

    VORTEX_API_LOGFILE=client_logfile.log,GENESIS_HOME=C:\Program Files\Micro Focus\extend 10.3.1\AcuGT,PATH=C:\Program Files\Micro Focus\extend 10.3.1\AcuGT\bin,LD_LIBRARY_PATH=C:\Program Files\Micro Focus\extend 10.3.1\AcuGT\bin,LIBPATH=C:\Program Files\Micro Focus\extend 10.3.1\AcuGT\bin

    After reboot the machine, the error persist.

  • Can you open a DOS prompt, as it is, and try the following command-line?

    odbcsql -d yourDSN

    If the PATH is loaded correctly, it should work from here.
    (odbcsql.bat is a batch file stored in the "BIN" folder of your AcuXDBC installation)

    This test is useful to understand if the DSN and the installation is correct.
    If it is, then the issue should be investigated in the LibreOffice configuration.

    If any error occurs, please provide the error and the output of the following command-line:

    echo %PATH%

    Thanks.

  •  

    C:\Program Files\Micro Focus\extend 10.3.1\AcuGT\bin>odbcsql -d MUCAM_SYSTEM

    VORTEXsql - Simple Interactive SQL.
    Version 2.0.5.2 (64-bit) - Production.
    Copyright ⌐ 1989-2020, Trifox, Inc., California, USA.
    All Rights Reserved Worldwide.

    ***** ERROR: DLLLOAD: acuxdbc11, The specified module could not be found.

    SQL (/? for help) ==> /q

    C:\Program Files\Micro Focus\extend 10.3.1\AcuGT\bin>echo %PATH%

    C:\Program Files\Micro Focus\extend 10.3.1\AcuGT\bin;C:\Program Files\Microsoft MPI\Bin\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files (x86)\Microsoft SQL Server\140\DTS\Binn\;C:\Program Files\Microsoft SQL Server\140\DTS\Binn\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\;C:\Program Files\Microsoft SQL Server\140\Tools\Binn\;C:\Program Files\dotnet\;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files\doxygen\bin;C:\ProgramData\chocolatey\bin;C:\Program Files\Micro Focus\extend 10.3.1\AcuGT\bin;C:\Users\92560\AppData\Local\Microsoft\WindowsApps;C:\tools\neovim\Neovim\bin;C:\Program Files\Micro Focus\extend 10.3.1\AcuGT\bin;

    C:\Program Files\Micro Focus\extend 10.3.1\AcuGT\bin>

  • So, you are in "C:\Program Files\Micro Focus\extend 10.3.1\AcuGT\bin"
    and the system cannot find a DLL that should be in that same directory,
    even with a %PATH% which looks correct.

    Can you try the following command-lines and report the outputs:

    cd C:\Program Files\Micro Focus\extend 10.3.1\AcuGT\bin
    dir .\acuxdbc11.dll
    tver .\acuxdbc11.dll

    Can you please confirm how you installed the software on this machine?

    Please, run again the ACU installer (I guess you used "extend(R) Version 10.3.1 x64.exe") and verify which AcuXDBC item you flagged in the "Product Selection" form.

    To have all the correct libraries for the AcuXDBC client driver, "AcuXDBC Data Interface for Windows" must be selected.

    Capture.JPG

    Looking forward for your feedback.

  •  the screen with the options that you show me never appears.

    These are the steps that appears to me:

    Screenshot from 2020-10-29 09-37-47.pngScreenshot from 2020-10-29 09-38-07.pngScreenshot from 2020-10-29 09-40-56.pngScreenshot from 2020-10-29 09-41-13.pngScreenshot from 2020-10-29 09-41-29.pngScreenshot from 2020-10-29 09-41-44.pngScreenshot from 2020-10-29 09-42-06.png

    c:\Program Files\Micro Focus\extend 10.3.1\AcuGT\bin>dir .\acuxdbc03.dll
    Volume in drive C has no label.
    Volume Serial Number is 2E12-96FE

    Directory of c:\Program Files\Micro Focus\extend 10.3.1\AcuGT\bin

    2020-05-01 03:25 PM 34,304 acuxdbc03.dll
    1 File(s) 34,304 bytes
    0 Dir(s) 52,240,105,472 bytes free

    c:\Program Files\Micro Focus\extend 10.3.1\AcuGT\bin>dir .\acuxdbc11.dll
    Volume in drive C has no label.
    Volume Serial Number is 2E12-96FE

    Directory of c:\Program Files\Micro Focus\extend 10.3.1\AcuGT\bin

    2020-05-01 03:25 PM 59,392 acuxdbc11.dll
    1 File(s) 59,392 bytes
    0 Dir(s) 52,239,777,792 bytes free

    PS C:\Program Files\Micro Focus\extend 10.3.1\AcuGT\bin> (Get-Item acuxdbc03.dll).VersionInfo

    ProductVersion FileVersion FileName
    -------------- ----------- --------
    @(T)TCM 4.0.0.26 @(T)TCM 4.0.0.26 C:\Program Files\Micro Focus\extend 10.3.1\AcuGT\bin\acuxdbc03.dll


    PS C:\Program Files\Micro Focus\extend 10.3.1\AcuGT\bin> (Get-Item acuxdbc11.dll).VersionInfo

    ProductVersion FileVersion FileName
    -------------- ----------- --------
    @(T)TDB 5.0.0.4 10,0,1,174 C:\Program Files\Micro Focus\extend 10.3.1\AcuGT\bin\acuxdbc11.dll

     

    Thanks.

  • Verified Answer

     , thank you again for all the information you've been available to share here.

    I think the standalone setup you use may have some issue.
    I will investigate this further as soon as possible.
    It may be missing (or mis-writing) some registry settings, or similar.

    In the while, would you like to use the full 1031win64.zip setup ?

    I invite you to contact your provider, in case you cannot download it personally.

    Hopefully this will help you and let you go on with your tests.

    Best Regards.

  • Thanks a lot  

    I will contact Juan, to use the .zip setup.

    Thanks!

  •  

    With the full .zip setup worked fine!

     

    Thanks a lot!

Reply Children
No Data