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!

Splunk is Nurturing Tomorrow’s Cybersecurity Leaders Today

Meet Carol Wright. She leads the Splunk Academic Alliance program at Splunk. The Splunk Academic Alliance ...

Part 2: A Guide to Maximizing Splunk IT Service Intelligence

Welcome to the second segment of our guide. In Part 1, we covered the essentials of getting started with ITSI ...

Part 1: A Guide to Maximizing Splunk IT Service Intelligence

As modern IT environments continue to grow in complexity and speed, the ability to efficiently manage and ...