sql icon indicating copy to clipboard operation
sql copied to clipboard

ODBC Driver 1.13.0.0 not working with ODFE SQL Plugin version < 1.13.0.0

Open allenphilip93 opened this issue 4 years ago • 1 comments

Hi,

I'm trying to connect PowerBI to my AWS ES cluster (ODFE v1.11.0, ES 7.9.1). I installed the ODBC driver v1.13.0 using the msi installer. From my machine I'm able to reach the server on command line but when I try to add a new ODN or connect from PowerBI it throws and error.

I did manage to find a similar issue. After that I tried to install the ODBC driver v1.11.0 but couldn't find the msi installer on the site so tried building from source.

I followed the instructions provided and had errors that "AWSFindPackage was not found in CmakeLists.txt". I was able to resolve this by cloning the aws repo using git clone --recurse-submodules https://github.com/aws/aws-sdk-cpp.git. The build appeared to complete successfully but there was no PROJECT.vcproj file generated at build/odbc folder.

  • Is there any public link to a v1.11.0 msi installed for windows x64? I tried this from issue but the link doesn't work for me.
  • If the installer is not available, please find attached my logs and kindly advise how to proceed. build_win_x64_release.log build_msi.log

allenphilip93 avatar Aug 04 '21 04:08 allenphilip93

I was able to resolve the build error by installing the WiX toolset and the msi installer was successfully generated. But upon installing the DSN still failed with an error. image

I ran Process Monitor and found that some of the dependencies were missing. image

Any thoughts on what I'm missing here?

allenphilip93 avatar Aug 04 '21 14:08 allenphilip93