All Apps and Add-ons

DB connect 2: Is "-" allowed in database names?

suarezry
Builder

I'm running Splunk v6.2.2 with DB Connect v2.0.2 to connect to MS SQL Server 2008 R2. I am able to Validate the connection. When trying to Query, I am able to select the Catalog but I get "No schema found". The database is called "vmware_vdi-events". Is "-" allowed in database names? If not then is there a workaround (I'm unable to change the database name)?

I am getting this error in dbx2.log:

06/04/2015 14:41:15 [ERROR] [init.py] Incorrect syntax near '-'.
Traceback (most recent call last):
File "/opt/hunk/lib/python2.7/site-packages/splunk/rest/init.py", line 184, in dispatch
methodOutput = method()
File "/opt/hunk/etc/apps/splunk_app_db_connect/bin/dbinfo.py", line 44, in handle_GET
return self.get_schemas(conn, cat)
File "/opt/hunk/etc/apps/splunk_app_db_connect/bin/health.py", line 206, in wrap_it
return w.logIt (self, f, l, *args, **kwargs)
File "/opt/hunk/etc/apps/splunk_app_db_connect/bin/health.py", line 177, in logIt
if err : raise err
AvroRemoteException: Incorrect syntax near '-'.

Tags (2)

worshamn
Contributor

Have a similar issue, mine says incorrect syntax near '.'
My database name has both a space and '-' in it. Seems to be a bug to me. When I switch to advanced query mode and put brackets [ ] around the database name in question (instead of quotes), I am able to return results.

0 Karma
Get Updates on the Splunk Community!

Automatic Discovery Part 1: What is Automatic Discovery in Splunk Observability Cloud ...

If you’ve ever deployed a new database cluster, spun up a caching layer, or added a load balancer, you know it ...

Real-Time Fraud Detection: How Splunk Dashboards Protect Financial Institutions

Financial fraud isn't slowing down. If anything, it's getting more sophisticated. Account takeovers, credit ...

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

 Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...