Problem with the odbc driver for power bi connection - TBC

[MrHertz]

Hi,

I’m following up on Problem with the odbc driver for power bi connection since I have the same problem.

I run Couchbase 7.2.4 in a Docker container on a Windows 11 computer with 128GB RAM, trying to use Power BI via the ODBC connector.

I followed the steps in Couchbase Power BI Connector | Couchbase Docs but got the same 126 error, indicating that the DLL could not load its dependencies.

So, I looked into the couchbaseodbcw.dll with Dependency Walker and found this:

It seems that more than 50 dependencies are missing.
Are there any other missing MSI packages that should be installed (from Microsoft)?

Thanks!
All the best / Hakan

[mreiche]

Did you first :

Verify Power BI Version

Before you proceed, verify that you have a supported version of Microsoft Power BI Desktop installed. The Couchbase Power BI Connector requires Power BI Desktop version March 2017 or later.

If necessary, download Power BI Desktop from the Microsoft downloads page.

[MrHertz]

Hi @mreiche, and many thanks for your reply!

My current version of Power BI Desktop is 2.129.1229.0 (24.05), which was released in May 2024.

I still have the problem and look forward to finding the solution with your help.
All the best / Hakan

[MrHertz]

Hi, @mreiche and all the others who have a similar problem.

Using the tool “Dependencies” (found here: GitHub - lucasg/Dependencies: A rewrite of the old legacy software "depends.exe" in C# for Windows devs to troubleshoot dll load dependencies issues.) I found the root cause of this problem.

couchbaseodbcw.dll are looking for two files that could not be found in my path:
libcrypto-1_1-x64.dll and libssl-1_1-x64.dll.

After finding these files in another folder (not related to the installation of OpenSSL), I copied those files to C:\Program Files\couchbase-odbc\bin, and the problem was solved.

All the best / Hakan

[photomorre]

I would like to know why Couchbase installer did not validate the existance of these files in the correct place.

Happy to get an answer or get a fix for the next version.

/Morre

[mreiche]

I opened a ticket - https://issues.couchbase.com/browse/ODBCC-42

[janhaviTripurwar]

Hi,
What is the output of the openssl version?

If the OpenSSL path is not correctly added in the env variables, the installer will not be able to find it (unless present in the C:\Program Files\couchbase-odbc\bin)

Couchbase Power BI Connector | Couchbase Docs.

[MrHertz]

Hi, and sorry for the late reply.

OpenSSL is installed, as required, and the result of “openssl version” is “OpenSSL 3.3.0 9 Apr 2024 (Library: OpenSSL 3.3.0 9 Apr 2024)”

The installed files are stored at C:\Program Files\OpenSSL-Win64\bin which also is present in the System variable “Path”.

Please note that the files that were missing (libcrypto-1_1-x64.dll and libssl-1_1-x64.dll) is not present in the bin-folder.

All the best / Hakan

[janhaviTripurwar]

Hi @MrHertz , What version of couchbase-odbc driver is installed? It looks like a version mismatch.
Could you try installing [couchbase-odbc-1.1-win64.msi] from the docs?

The couchbase-odbc-1.1 driver depends on libcrypto-3-x64.dll and and libssl-3-x64.dll and not the 1_1 versions as seen in the screenshot from the dependency walker.