If you have no access to the fily system, try to ask the DB admins to create a view/stored function on the server side and do select * from the view/stored function. ... View more

DB Connect v2 doesn't accept a slash in a SQL query because this sign is defined as reserved in urllib.py file. For resolution of the issue see my comment in a similar topic (https://answers.splunk.com/answers/341611/splunk-db-connect-2-slash-in-sql-query-always-retu.html#answer-392823) please: To resolve the issue, you should edit $SPLUNK_HOME/etc/apps/splunk_app_db_connect/bin/dbxquery.py: change the line (usually its number is 123) query = urllib.quote(query) to query = urllib.quote(query, safe='') Don't forget to make a backup copy before editing. Take care to keep changes after upgrades. ... View more

To resolve the issue, you should edit $SPLUNK_HOME/etc/apps/splunk_app_db_connect/bin/dbxquery.py: change the line (usually its number is 123) query = urllib.quote(query) to query = urllib.quote(query, safe='') Don't forget to make a backup copy before editing. Take care to keep changes after upgrades. ... View more