All Apps and Add-ons

How do I resolve this odbc connector error?

bradyguy
Engager

I am getting an error message when I attempt to connect to splunk via the odbc driver from excel. [60] Unexpected response from server. Verify the server URL. Error parsing JSON: Expect either an object or array at root

I am using the 32bit version.

We have splunk enterprise installed. In the host box I am using the server path to one of the search heads. I have the verify ssl certificate unchecked; And in the server.conf the requireClientSSL... is not in there and the default of false should be applied.

Labels (1)
Tags (3)
1 Solution

skylasam_splunk
Splunk Employee
Splunk Employee

Hi,
Please do the following -
1. Open 32-bit ODBC administrator panel.
2. Click the System DSN tab; select the Splunk DSN and click configure.
3. What does your Server URL setting have ? It should be set like this - https://:; e.g https://10.225.196.112:8089
4. Make sure that the mgmt port on your Splunk search head is not being blocked by your firewall.

View solution in original post

0 Karma

pwesterbeek
Engager

It took me days but I found the solution. Version 2.1.0 doesn't work with Splunk 6.4.1 You have to use version 2.0.0 You can download it here : https://splunkbase.splunk.com/app/1606/release/2.0.0/agree/

0 Karma

pwesterbeek
Engager

It took me days but I found the solution. Version 2.1.0 doesn't work with Splunk 6.4.1 You have to use version 2.0.0 You can download it here : https://splunkbase.splunk.com/app/1606/release/2.0.0/agree/

0 Karma

skylasam_splunk
Splunk Employee
Splunk Employee

Hi,
Please do the following -
1. Open 32-bit ODBC administrator panel.
2. Click the System DSN tab; select the Splunk DSN and click configure.
3. What does your Server URL setting have ? It should be set like this - https://:; e.g https://10.225.196.112:8089
4. Make sure that the mgmt port on your Splunk search head is not being blocked by your firewall.

0 Karma

bradyguy
Engager

cool this was the answer I needed; I think it was I was on the wrong port.

0 Karma

ssuluguri
Path Finder

Hi ,

I have got similar request to configure between splunk cloud and powerBI ,

 

I am getting below error .

"Verify the server URL. Error parsing JSON: Expect either an object or array at root"

 

Can someone help on this .

0 Karma
Get Updates on the Splunk Community!

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...