ODBC connection getting error [40]error with http api.

[ujju]

I am trying to use Splunk ODBC Driver for splunk 6.0 with microsoft excel 2010 32bit version.
I have installed the ODBC and given the server path as https://:8089. I have unchecked the verify ssl certificate. But I am getting error “[40]error with http api, error code couldn't connect to the server”.

Can you help me out here. Expecting an quick reply.
Thanks in advance.

[ssreshta_splunk]

Hello,

Probably your server might refuse connections without a valid cert. Can you please tell me what do you see if you paste https://:8089 in the browser?

[ywu_splunk]

Try that URL under a browser. If it works, and if the browser has proxy settings, then you would need to apply similar settings for the Splunk ODBC driver. Refer to http://docs.splunk.com/Documentation/ODBC/1.0/UseODBC/ProxyServerConfiguration for how to do this.

Let me know if this is the issue or not.

[ujju]

Hi ssreshta_splunk,

I am getting the message" proxy server does not responding."

[ywu_splunk]

Could you provide more details? Such as what is the proxy address, and what env variable did you set?

The error message may indicate the proxy server address being set is not reachable.