Unable to Connect to MarkLogic via ODBC on CentOs

Question

We've got a MarkLogic server running on CentOS with an ODBC endpoint defined. When I attempt to connect to it via Power BI with ODBC, I get the error below.

I've got a similar MarkLogic server running locally, and I don't have any issues connecting via ODBC.

Notes:

• Testing the connection using ODBC Data Source Administrator is successful
• MarkLogic running on the CentOS server is version 9ea

There's nothing in the 8052_ErrorLog.txt, however, in the 8052_AccessLog.txt I see this:

192.168.21.34 - nickh [23/Mar/2017:09:43:36 -0400] init
192.168.21.34 - nickh [23/Mar/2017:09:43:36 -0400] password
192.168.21.34 - nickh [23/Mar/2017:09:43:36 -0400] query
192.168.21.34 - nickh [23/Mar/2017:09:43:36 -0400] query
192.168.21.34 - nickh [23/Mar/2017:09:43:36 -0400] query
192.168.21.34 - nickh [23/Mar/2017:09:43:36 -0400] query
192.168.21.34 - nickh [23/Mar/2017:09:43:36 -0400] query
192.168.21.34 - nickh [23/Mar/2017:09:43:36 -0400] terminate

Answer 1

Not a terribly satisfying answer, but this appears to be a known issue with MarkLogic 9ea running on CentOS. According to the MarkLogic support forums:

Thanks for looking further into this problem. It looks like you’re running into a bug that we discovered and fixed recently – so this ought to work in 9.0-1.

John

https://ea.marklogic.com/forums/topic/odbc-connection-from-excel-doesnt-work/#post-3031 (link requires MarkLogic EA access)

Issue is reported to be fixed for the production release which is expected around May.