Windows 10 - ODBC driver - libreoffice - acuxdbc03

[fbenedic]

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

[shjerpe]

Have you used ODBC Data Source Administrator 64 bit and set up an AcuXDBC DSN?

That would be the first thing to do.

[fbenedic]

Hi @shjerpe 

The followings are the screenshots of the configurations that i did.

Thanks!

[shjerpe]

Based on the setting I see in dsn1.png you are configuring the DSN to use AcuXDBC Server - that's what the network driver checkbox and hostname field are for. Have you started AcuXDBC Server?

https://www.microfocus.com/documentation/extend-acucobol/1031/extend-Interoperability-Suite/GUID-1F56073B-4769-45E0-B55A-ADF3A5EFA098.html

[fbenedic]

Yes, i have started.
I can access from a Linux machine through JDBC.

[fbenedic]

Yes. I have started the server.

I can access from a Linux machine through JDBC.

[Claudio_Contardi]

@fbenedic 

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.

[fbenedic]

@Claudio_Contardi 

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.

[Claudio_Contardi]

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.

[fbenedic]

@Claudio_Contardi 

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>

[Claudio_Contardi]

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.

Looking forward for your feedback.

[fbenedic]

@Claudio_Contardi the screen with the options that you show me never appears.

These are the steps that appears to me:

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.