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.

[99eaglez]

Probably proxy server (or firewall).

Typically proxy server because the ODBC driver is not proxy aware like your internet browser is.

This is why others mentioned configure the proxy without explanation.

The typical solution is to add an environmental variable that the ODBC driver can see.

I would recommend testing it using the following process:

1. At the command line (in Windows) enter setx http_proxy <proxy_ip>:<proxy_port> (example setx http_proxy 132.50.12.1:443)
2. Restart your ODBC Program (ex, PowerBi)
3. Retest your connection

If it fails, add the https_proxy the same way. If it succeeds, add it the system permanently. 

Ref# Configure the proxy server - Splunk Documentation
# libcurl - programming tutorial
# Set up proxy using http_proxy & https_proxy environment variable in Linux? | GoLinuxCloud
# windows - Command line to remove an environment variable from the OS-level configuration - Stack Ove...

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

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

[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?