Splunk ODBC Error 60

Question

I have installed Splunk ODBC 32-bit with the following configuration for my 32-bit Excel application to access some saved Splunk queries :

Data Source name - Splunk ODBC 32  
login ID - myusername
Password -    ********* 
Server  URL - "http://splunkserver:443" 
Unchecked "Verify Server SSL Certificate"

However, every time I try connecting to Splunk using Query Editor in Excel , I get this error : "[60] Unexpected response from server. Verify the server URL. Ero parsing JSON:Expect either an object or array at root"

The server URL is working fine when I checked it directly from the browser.

Please let me know how this can be resolved.

Thanks in advance

Jon Webster Jon Webster · Accepted Answer · 2014-08-01T04:18:59

The ODBC driver should be connecting to the Splunk Management port, which by default is 8089. Try http://splunkserver:8089, or https.

Good luck!

Splunk ODBC Error 60

2 Answers