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 Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI!Discover how Splunk’s agentic AI ...

Splunk Enterprise Security 8.x: The Essential Upgrade for Threat Detection, ...

Watch On Demand the Tech Talk on November 6 at 11AM PT, and empower your SOC to reach new heights! Duration: ...

Splunk Observability as Code: From Zero to Dashboard

For the details on what Self-Service Observability and Observability as Code is, we have some awesome content ...