Installation

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

ujju
New Member

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.

Tags (2)
0 Karma

99eaglez
Explorer

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

 

0 Karma

ujju
New Member

Hi ssreshta_splunk,

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

0 Karma

ywu_splunk
Splunk Employee
Splunk Employee

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.

0 Karma

ywu_splunk
Splunk Employee
Splunk Employee

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.

0 Karma

ssreshta_splunk
Splunk Employee
Splunk Employee

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?

0 Karma
Get Updates on the Splunk Community!

Why You Can't Miss .conf25: Unleashing the Power of Agentic AI with Splunk & Cisco

The Defining Technology Movement of Our Lifetime The advent of agentic AI is arguably the defining technology ...

Deep Dive into Federated Analytics: Unlocking the Full Power of Your Security Data

In today’s complex digital landscape, security teams face increasing pressure to protect sprawling data across ...

Your summer travels continue with new course releases

Summer in the Northern hemisphere is in full swing, and is often a time to travel and explore. If your summer ...