Join the Conversation
- Find Answers
- :
- Apps & Add-ons
- :
- All Apps and Add-ons
- :
- All Apps and Add-ons
- :
- Re: odbc connector
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark Topic
- Subscribe to Topic
- Mute Topic
- Printer Friendly Page
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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://
4. Make sure that the mgmt port on your Splunk search head is not being blocked by your firewall.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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/
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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/
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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://
4. Make sure that the mgmt port on your Splunk search head is not being blocked by your firewall.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
cool this was the answer I needed; I think it was I was on the wrong port.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 .
Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!
Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.
May 2026 Splunk Expert Sessions: Security & Observability
Network to App: Observability Unlocked [May & June Series]
SPL2 Deep Dives, AppDynamics Integrations, SAML Made Simple and Much More on Splunk ...
