Highlighted
Commander
Commander
1345 views

Windows 10 - ODBC driver - libreoffice - acuxdbc03

Jump to solution

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

0 Likes
1 Solution

Accepted Solutions
Highlighted
Micro Focus Expert
Micro Focus Expert

@fbenedic , 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.

----------------------------
Claudio Contardi
Product Support Engineer, Senior
Micro Focus

View solution in original post

0 Likes
16 Replies
Highlighted
Micro Focus Expert
Micro Focus Expert

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

That would be the first thing to do.

0 Likes
Highlighted
Commander
Commander

Hi @shjerpe 

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

 

Thanks!

0 Likes
Highlighted
Micro Focus Expert
Micro Focus Expert

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

 

0 Likes
Highlighted
Commander
Commander
Yes, i have started.
I can access from a Linux machine through JDBC.
0 Likes
Highlighted
Commander
Commander

Yes. I have started the server.

I can access from a Linux machine through JDBC.

0 Likes
Highlighted
Micro Focus Expert
Micro Focus Expert

@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.

----------------------------
Claudio Contardi
Product Support Engineer, Senior
Micro Focus
0 Likes
Highlighted
Commander
Commander

@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.

0 Likes
Highlighted
Micro Focus Expert
Micro Focus Expert

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.

----------------------------
Claudio Contardi
Product Support Engineer, Senior
Micro Focus
0 Likes
Highlighted
Commander
Commander

@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>

0 Likes
Highlighted
Micro Focus Expert
Micro Focus Expert

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.

----------------------------
Claudio Contardi
Product Support Engineer, Senior
Micro Focus
0 Likes
Highlighted
Commander
Commander

@Claudio_Contardi 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.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.